ODBCConnection Execute Select
Hello,
I am trying to execute Select using ODBCConnection. I constructed sql string and then tried to execute it.
sqlstr = "SELECT [Order].order_status_id, Claim.claimstatus_id FROM [Order] INNER JOIN Claim ON [Order].claim_id=Claim.claim_id AND [Order].order_id=999999";
I get this error message. Does anybody know why?
Message (18:53:36)
1952621871 999999 19526218
Cannot read a record in ().
The SQL database has issued an error.
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
If I execute just this:
sqlstr = "SELECT [Order].order_status_id, Claim.claimstatus_id FROM [Order] INNER JOIN Claim ON [Order].claim_id=Claim.claim_id";
I don't get the error.
Thanks in advance.
|