RE: [DUG]: RE: Table busy
This still does not allow you to have a table opened exclusivly, as the Delphi IDE still has a copy of it open. It still think it would be nice if someone wrote an expert to close all tables in a project. Chris ps: I also think it would be nice if someone wrote an expert that would put all units used in the project, which are not standard ones into the project manager. Dam - I will probally have to do it if I ever find a free hour... 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 Grant Black Sent: Thursday, 8 April 1999 10:30 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
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
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
RE: [DUG]: RE: Table busy
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
RE: [DUG]: RE: Table busy
Wade has a thing called QueryCheck - which checks for open datasets in a project. It's a stand-alone tool for his own use, ie effective but not fully polished. However; you may be able to talk him into making it commercial - or incorporating it into TV. Max -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Crowe Sent: Thursday, 8 April 1999 10:16 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
