ODBC query

[Peterh]

Hi,

I am working on a solution to pull data out of our oracle database into FM v5.5. Pulling the data out of oracle isn't a problem, but I am not sure how to make the query I want dynamic. Here is a cut down version of the query:

SELECT "ORDERS"."TRAN_ID" FROM "ORDERS" WHERE "ORDERS"."TRAN_ID" = '2118570' ORDER BY "ORDERS"."TRAN_ID"

Instead of hardcoding '2118570' I would like to use a global FM field. It is possible to write something like "WHERE "ORDERS"."TRAN_ID" = "('FileMake file':'FileMaker field')?

In summary, I want to query an oracle database from FM using a FM field as the variable.

Is this possible?

Thanks.

[Vaughan]

A query can be stored in a field. Make a calculation field that generates the necessary text, and use lots of conditionals (If[], Case[] etc)to perform the necessary magic.

[Peterh]

I've figured it out now. I hadn't thought too hard about how fields would work.

Thanks.

[cdenby]

Wait a sec - how do you actually get the query to be run in an import if it sits in a field??