🚀 go-pugleaf

Hi,Steve!
        The version of ADO I'm using is "2.60.6526.0", maybe this is the
reason you said.But the strange thing is I still can do "select..."
operation by ADOQuery1->Open() after a Open operation has been done,but only
ExecSql() will not be work!How to resolve it?

Jimmy Lu China
Jimmy@chinafrida.com




"Steve Love" <steve.love2@virgin.net> wrote in message
news:20011108.8365839@sl.engineering...


> Hi,everyone!
>         In my application,I select some records from a table by
> ADOQuery1->Open(),it's ok.And then,I'll use delete some records from a
> table, so I cleared the sql text by ADOQuery1->SQL->Clear(),and reassign
the
> sql text "delete from TABLE1 ...",and then use the ADOQuery1->ExecSQL()
to
> delete the records,but it doesn't work,what's the reason?
>         But if I delete the records by another new query ADOQuery2,it's
will
> be ok.But all the properties of ADOQuery1 and ADOQuery2 are the same.
why?
>         Thanks!

What version of ADO are you using?
(check the version of $Program Files\common files\system\ado\msado15.dll)
The reason I ask is because I am experiencing strange lifetime behaviour
when re-using a TADOQuery component with MDAC 2.6 and above, for code
which
works fine in MDAC 2.52 and below.

> Jimmy Lu China
> Jimmy@chinafrida.com
Steve