Passthrough query results

[Lorimare]

Greetings,

how can I have the results of a pass through query returned to ..say a local access query. SUch as:

strSQL = "select * from customercaster where state = 'MA'"

The above is passed to informix to run and how are the results returned to access? Can I store them in a query object?

 

[psemianonymous]

Yes. Go to query design. Close the 'add table' box. Now go to Query->SQL Specific->Pass-through (on Access 97, YMMV).

Now type in your SQL.

Now go to open the pass-through query. Link it to a data source.