Fetch Trans. Sales Entry from Navision 3.7

Would anyone help me please in the following:

i’ve been connected to Navision via C/ODBC, and i’ve fetched Item Table by the query

SELECT * FROM Item.

it was succeeded,

but when trying to fetch Trans. Sales Entry i’ve faced these errors

when the query is

“SELECT [Trans_ Sales Entry].[Transaction No_], [Trans_ Sales Entry].Quantity, [Trans_ Sales Entry].Date FROM [Trans_ Sales Entry] WHERE ((([Trans_ Sales Entry].Date)=#1/1/2009#))”

the message was

ERROR [42000] [Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]Expected lexical element not found: FROM

when the query was

“SELECT [Transaction No_], Quantity, Date FROM [Trans_ Sales Entry] WHERE (((Date)=#1/1/2009#))”

the message was

ERROR [42000] [Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]Unexpected extra token: Entry]

when the query was

"SELECT [Transaction No_], Quantity, Date FROM Trans_ Sales Entry WHERE Date= #1/1/2009# "

the message was

ERROR [42000] [Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]Unexpected extra token: Entry

and even more but no result…

can you help please…

Have you been able to make any successful request?

I’m always suggesting that uses test their ODBC using MSQuery. Did you try this?

Thank you sir for your kind reply,

kindly note that i’ve tested it as shown.