SQL Query problem

[Kevin222]

Hello everyone. I encountered a little problem when importing records using the Filemakers ODBC SQL query and 'calculated SQL text' option. I can make a very similiar query using the Query Builder, but then I cannot use any variables defined in my script window.

The query I get from the Query Builder is:

SELECT "my company$Sales Shipment Line"."Description"

FROM "my company$Sales Shipment Line"

WHERE "my company$Sales Shipment Line"."Document No_" = N'10101'

This should be altered so that the last number could be a variable like $document_no. I simply Cannot get this to work properly.

Just replacing the ":s with ':s won't solve the problem.

The best solution I came up with is

"SELECT 'my company$Sales Shipment Line.Description'

FROM 'my company$Sales Shipment Line'

WHERE 'my company$Sales Shipment Line.Document No_' ="& $document_no

but it does not work.