mORMot Open Source

noobies

Member

Registered: 2011-09-13

Posts: 139

FormatUTF8

try modernize code ClientRest.ExecuteList([], s) with FormatUTF8 (executelist need - have several commands inner join)
old part code (work fine):

Result := Result + 'strftime("%Y", InputDate) = ' + cbbCurrentYear.Value.QuotedString

if change old part to new part code not work:

Result := Result + FormatUTF8('strftime("%Y", InputDate) = ?', [], [cbbCurrentYear.Value]);

if result i see: ' strftime("Y", InputDate) = ?'. any idea how format sql with expression?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: FormatUTF8

Use %% within strftime("%Y",...)

noobies

Member

Registered: 2011-09-13

Posts: 139

Re: FormatUTF8

change to

Result := Result + FormatUTF8('strftime("%%Y", InputDate) = ?', [], [cbbCurrentYear.Value]);

and not work, in result: ' strftime("%Y", InputDate) = ?'

FormatUTF8 dont parse string with %% and dont change ? to

:(''2015''):

if i remove % all parse ok, but strftime not work, i think it but in FormatUTF8

Last edited by noobies (2015-06-04 07:14:16)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: FormatUTF8

Please try

Result := Result + FormatUTF8('strftime("%Y", InputDate) = ?', ['%'], [cbbCurrentYear.Value]);

noobies

Member

Registered: 2011-09-13

Posts: 139

Re: FormatUTF8

ab, big thanks it work!