ODBCConnection Execute Select

[gb]

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.

[Ned]

What type is [Order].order_id field?

[kashperuk]

when using filters, use the where clause instead
so:
join Claim on Claim.field=Order.field WHERE Order.field=99999

Hope this helps

[gb]

Order_ID is integer.

[gb]

It didn't help. I get the same error.

[gb]

thank you everyone

[kashperuk]

Well, share the solution with us, will you?

Thanks