Avoid Error in Advanced Query

Avoid Error in Advanced Query

  
When using Advanced Query be sure to have WHERE and ORDER BY in captials ...
otherwise you end up in funny error message ".... incorrect syntax near .outsystems"
Hi Joop

Can you give an example of a query with that problem? Sql is not case sensitive.

Regards,
João Rosado
It shouldn't be but it seems to be :-)
Hi Joop

Can you give an example of a query with that problem?
I could not replicate your problem. Works perfectly here with any case.

Regards,
João Rosado