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…