Hello

I've a query on my application that using the debbuger and the
evalute/modify windows looks:

'WHERE COALESCE(EMail,'')<>'' '#$D#$A#$D#$A'ORDER BY Moed'#$D#$A

On the the edbmanager, after I remove the machine symbols, runs fine
but during the runtime it's raise the error:
#700 ...(Expected ) but instead found ORDER)'.

What I'm missing or how can I find the error?

Thanks in advance
Sorin

More information. The code in the application is:

Query.Sql.Add('WHERE COALESCE(' +FieldName+ ','')<>'' ');



> I've a query on my application that using the debbuger and the
> evalute/modify windows looks:
>
> 'WHERE COALESCE(EMail,'')<>'' '#$D#$A#$D#$A'ORDER BY Moed'#$D#$A
>
> On the the edbmanager, after I remove the machine symbols, runs fine
> but during the runtime it's raise the error:
> #700 ...(Expected ) but instead found ORDER)'.
>
> What I'm missing or how can I find the error?
>
> Thanks in advance
> Sorin
>

Am 20.07.2012 11:51, schrieb Sorin H:
> Query.Sql.Add('WHERE COALESCE(' +FieldName+ ','')<>'' ');

The problem are missing quotes. Try this:

Query.Sql.Add('WHERE COALESCE(' + FieldName + ','''') <> ''''');

Uli