Re: Unprepare an TADOQuery?

Daniel Voelkel wrote:

> 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
>

if i understood you right, you are using ExecSQL to return a SELECT
statement. That's not a good idea. For any query that returns a cursor
you should use Open instead


--
Best regards :)

Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.

Relevant Pages

  • Unprepare an TADOQuery?
    ... is there a way to unprepare a TAdoQuery? ... - execSQL a Query which uses the temp table ... So I guess that the Query gets prepared and stays prepared ... On the next ExecSQL I get the described ...
    (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)