Dialog text:
ODBC Error -1: "The query returned an error (ODBC State: HY000)Error:NexusDB: : Query preparation failed:
Syntax error at line 3 pos 16: '-', '*', '/', ';', ||, '+', , AND, EXCEPT, GROUP, HAVING, INTERSECT, OR, ORDER or UNION expected [no error code]Query:SELECT M.IntroCode, count(L.ClientReference) AS RecCount FROM "Loans" L, "MainClientData" M where M.ClientReference=L.ClientReference and
L.OriginalDueDate between date'2014-02-01' and date'2014-02-28' and not L.IsReloan and n" (HY000)
Issued by: ODBCView Application
Jump to the FaultWire page for Solutions and Fixes for this topic...