Page 1 of 1

Using {ts in SQL Server

Posted: Fri 09 May 2014 01:54
by 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.

Re: Using {ts in SQL Server

Posted: Mon 12 May 2014 06:33
by AlexP
Hello,

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

Re: Using {ts in SQL Server

Posted: Mon 12 May 2014 16:04
by yeohray2
Thanks, that worked.

Re: Using {ts in SQL Server

Posted: Tue 13 May 2014 06:58
by AlexP
Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.