Using {ts in SQL Server

[yeohray2]

In SQL Server, the following WHERE condition is valid:

Code: Select all

WHERE (DocumentDate > {ts '2011-08-01 00:00:00'}) 

However, if I run a query with this condition, Unidac treats it as a macro and returns a blank value, causing the SQL statement to fail. Is there a way to tell Unidac to not use macros, and leave the SQL statement intact?

Thanks in advance.

[AlexP]

Hello,

To solve the problem, you should set the EnableUniSQL global variable to False.

[yeohray2]

Thanks, that worked.

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.