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.
