What about transactions??
Are you using them ??
Else Blame the BDE for yet another bug ...
As to your question, I think the answer is that if the App starts with it
closed, it has never been opened, hence no problem.
Maybe a handle is still allocated? Or what is your transaction isolation
level??
Can't say I've seen this BDE problem before - seen plenty of others.
Myles.
> -----Original Message-----
> From: Grant Black [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 11, 1999 11:48 AM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: When is a query closed?
>
> I have a simple TQuery (SELECT * FROM TelFiles) called qTelFiles. On
> the same form I also have a delete..all records Query - (DELETE FROM
> TelFiles) called qDeleteAllTelFiles.
>
> If I start the app up with the select query closed then the delete
> query works fine. If I try and do the following then it does not work -
> I get a GPF in IDQry01.dll
> ..
> qTelFiles.Close;
> // tried qTelFiles.Unprepare
> qDeleteAllTelFiles.ExecSQL;
> qTelFiles.Open;
> ..
>
> Question is why does Closing the query before running the app work and
> not in the above code?
>
>
>
> Grant Black
> Team Leader - PC Tools
>
> SmartMove (NZ) Ltd
> Phone: +64 9 361-0219 extn 719
> Fax : +64 9 361-0211
> Email: [EMAIL PROTECTED]
>
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
