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)
  • Re: Truncation Issue w/ Strings
    ... I was getting the results from an access query, so I ended up having to ... create a temp table, and insert the rows into a memo field in the temp ... "fdhsjak hfdjksh fdshfjkdlsh fjdshfj hdslfh dshfjlshjfhdsjflhdsjlfh ... dsjlkhfjdshfjdha jfdhj f " & _ ...
    (microsoft.public.vb.general.discussion)
  • Re: query unique count for field
    ... I am not looking for a 1 to n sequence across the whole ... Start with such a temp table empty of ... >> Having succeeded with Michel's advice, I now have a query with the correct ... >>> where table Iotas has a single field, iota, with values from 1 to nnn, ...
    (microsoft.public.access.queries)
  • Re: deleting columns in table
    ... Doug Steele, Microsoft Access MVP ... To delete the contents of the temp table, you need a Delete query: ...
    (microsoft.public.access.modulesdaovba)
  • Re: comparing a record in one table against a record in another using VBA
    ... , then the 2nd query ... copies everything in Temp to Main on the condition that the primary ... Then I've called these queries using VBA ... I have 3 tables storing information about people; Main, Temp and Dupl. ...
    (comp.databases.ms-access)