0 Replies Latest reply on Jun 3, 2010 4:56 AM by Kevin222

    Database importing problem



      Database importing problem


      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.