SQL Query problems with NF2.6/ ODBC

12stephan34
12stephan34 Member Posts: 6
edited 2004-02-10 in Navision Financials
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

Comments

  • klix
    klix Member Posts: 1
    Disable the ODBC drivers "Commit Cache".
  • 12stephan34
    12stephan34 Member Posts: 6
    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 :D ?! I didn't find this answer in the official docs (unfortunately)...

    take care,

    Stephan

Categories