ODBC/ASP.NET Question

gmorken

Hello,

I'm writing a asp.net application to collect data from Navision table Item Ledger Entry.
My system-DSN is like this:
Identifiers: All except spaces
Langugae: English (USA)

My Select syntax from VS2005 is:
navOdbcCommand.CommandText = "SELECT Item_Ledger_Entry.Cost_Amount_(Actual) FROM Item_Ledger_Entry";

This generates runtimeerror:
ERROR [42000] [Navision a/s][Navision Attain ODBC Driver]Expected lexical element not found: FROM

Is it the () thats the problem?
How can I rewrite this?

Regards

Yaroslav_Gaponov

gmorken wrote:

Hello,

I'm writing a asp.net application to collect data from Navision table Item Ledger Entry.
My system-DSN is like this:
Identifiers: All except spaces
Langugae: English (USA)

My Select syntax from VS2005 is:
navOdbcCommand.CommandText = "SELECT Item_Ledger_Entry.Cost_Amount_(Actual) FROM Item_Ledger_Entry";

This generates runtimeerror:
ERROR [42000] [Navision a/s][Navision Attain ODBC Driver]Expected lexical element not found: FROM

Is it the () thats the problem?
How can I rewrite this?

Regards

Hi

The tables belong to company only usualy have ms sql name like[company$table]

gmorken

Im running Navision 3.60 Native

IHateTechnology

gmorken,
Try

SELECT [Cost Amount (Actual)] FROM [Item Ledger Entry]