ODBC import and script

[repro]

I have an sql query which works fine when the query is pasted into the import box, however I want to do a calculation where the last 5 digits are a job number which changes like this

SELECT "JobDescription"."JobNo", "JobDescription"."Description"

FROM "JobDescription"

WHERE "JobDescription"."JobNo" = XXXXX

where XXXXX is my job number which changes but I cannot get it to work as a calculation either by pasting the above text plus the job no. field or by creating a field which holds the result and using that in the calculation.

Sorry if a little muddled first few steps into Filemaker and SQL

[mattley]

Try creating a calcultion field which holds the entire query, so

= "select .......

... WHERE..." & & ""

then use that field as the calculated SQL.

Hope that makes sense.

[insta_gator]

Here's an example using Access. Don't forget to set up the DSN first.

ODBC.zip

Edited July 29, 2005 by Guest