Hello,
We (my partner and I) had a situation come up yesterday that we were able to
get around, but I'd like input on what the best practice might be.
I have a temporary resultset that I'd like to join with another SQL, or use
in a subquery in another SQL. FYI - I'm using Microsoft Visual FoxPro,
connecting to an IDS v7.3 instance via the current ODBC drivers from IBM.
What we ran into was that our initial SQL ended up as a local FoxPro cursor,
which of course could not be referenced within another SQL statement sent
over the ODBC connection. The solution was to parse the cursor and assemble
a new SQL statement with an "WHERE IN (ValueList)" clause.
Is there a way to create a temporary cursor on the Informix server that I
can reference in other SQL statements via an ODBC connection? Any
information would be helpful.
Thanks.
--
William Fields
MCSD - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ
"I have no special talents, I am only passionately curious"
- Albert Einstein