That wouldnt solve John's original question, as it was having the table live
at design time that was causing the problem (as you know, when you run in
the Delphi IDE, the design-time forms are just hidden).
Andrew Cooke.
> -----Original Message-----
> From: Grant Black [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 08, 1999 10:30 AM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: RE: Table busy
>
> I, <smug/self-rightous tone on> have all my queries in datamodules and
> have a init proc in the datamodule called CloseAll that looped through
> all TTables & TQuerys and closed them & Prepares the queries.
>
> Solves the problem as I often like to have queries & table live at
> design time...
>
>
> Grant Black
> Software Developer
> SmartMove (NZ) Ltd
> Phone: +64 9 361-0219 extn 719
> Fax : +64 9 361-0211
> Email: [EMAIL PROTECTED]
>
>
> > -----Original Message-----
> > From: Chris Crowe [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 08, 1999 10:16 AM
> > To: Multiple recipients of list delphi
> > Subject: RE: [DUG]: RE: Table busy
> >
> >
> > It would be good if someone wrote an expert that told you
> > which tables you have left open in your forms. It can be a
> > real pain to find those tables, as all tables should be shut
> > and you explicitly open them IMHO.
> >
> > Chris
> >
> > Christopher Crowe (Software Developer)
> > Microsoft MVP, MCP
> >
> > Adrock Software
> > Byte Computer & Software LTD
> > P.O Box 13-155
> > Christchurch
> > New Zealand
> > Phone/Fax (NZ) 03-3651-112
> >
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Cooke, Andrew
> > Sent: Thursday, 8 April 1999 09:50
> > To: Multiple recipients of list delphi
> > Subject: [DUG]: RE: Table busy
> >
> >
> > Although its hidden the form you were working on in Delphi is
> > still sitting
> > there, with the table open. If you close Delphi, and run your
> > .exe directly,
> > you'll find the problem goes away. The other option is to close that
> form
> > before running the application from within Delphi, or (the recommended
> > option) once you have set up your tables etc, make sure that they
> > are closed
> > on the design time form.
> >
> > Regards,
> > Andrew Cooke.
> >
> > > -----Original Message-----
> > > From: John Christenhusz [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, April 08, 1999 9:02 AM
> > > To: Multiple recipients of list delphi
> > > Subject: Table busy
>
> ------------------------------------------------------------------------
> ---
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
