Unprepare an TADOQuery?

Hi,

is there a way to unprepare a TAdoQuery? I need this to do the following:

- create and fill a temp table
- execSQL a Query which uses the temp table
- use the data in further queries
- drop the temp table

This worked fine with BDE and it works for the first "run". When I rerun
this procedure, then I get an error like "table modified, dropped or
renamed". When I use an other TADOQuery with the same SQL it works fine for
one more time. So I guess that the Query gets prepared and stays prepared
with the ID of the "old" Temptable. On the next ExecSQL I get the described
error. I use D7E, D2005E and Informix CSDK 2.90 TC3.

Any workaround wold help me too.

Thanks in advance,
Daniel
.

Relevant Pages

  • Re: Unprepare an TADOQuery?
    ... > is there a way to unprepare a TAdoQuery? ... > - execSQL a Query which uses the temp table ... you are using ExecSQL to return a SELECT ... For any query that returns a cursor ...
    (borland.public.delphi.database.ado)
  • DROP OR ADD COLUMN Problems in PostgreSQL Database
    ... I am using TADOQuery to to DROP or ADD Column from a simple table in ... "Bind message has 6 results formats but query has 5 columns" ... I just now even created a temp table with the same structure as the ...
    (comp.lang.pascal.delphi.databases)
  • Re: Informix vs Oracle vs DB2. SQL Query optimization.
    ... but I think you're confused because you don't know Oracle. ... the query chooses to limit TAB_A by the col_id. ... initially we have the collection as geo1. ... case of 270,000 rows in the collection, and 60,000 rows in the temp ...
    (comp.databases.informix)
  • Re: Relationships, back end
    ... query the same, using the linked file directly rather than a temp table. ... |> into tblMovements but into a temp table, ... | adds the EquipmentID field the the temp table". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Multi column update
    ... The example I've given is a sort of simplified version of my query, ... limited by how fast the server is able to write the redo information. ... temp table, and then reference that temp table with your update query: ... will be written to the trace file. ...
    (comp.databases.oracle.misc)