SQL Query problems with NF2.6/ ODBC

12stephan34

Dear list,

I currently have problems of executing a SELECT statement on the Navision Financials 2.6 ODBC driver.
The statement looks like

SELECT * FROM Table WHERE Table.MyDateField >= {d '2004-01-15'}

The error message isn't that self-descriptive. It just outputs 'Internal Error' (in MS Query).
Does anyone have tips and tricks around querying with date fields?

Thanks in advance and

Kind regards,

Stephan

klix

Disable the ODBC drivers "Commit Cache".

12stephan34

klix wrote:

Disable the ODBC drivers "Commit Cache".

Yes! That did the job! Thanks for the answer. I assume that you're a Navision employee or where did you get this insider knowledge ?! I didn't find this answer in the official docs (unfortunately)...

take care,

Stephan