Hello everyone! I encountered a little problem when importing records using the Filemaker ODBC SQL query and choosing the 'calculated SQL text' option. I can make a very similiar query using the Query Builder and it works, 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.
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, the syntax is still wrong somehow. Iam using FM10. Also note that I cannot change the database or table names which are a bit peculiar.