[DUG] Open / Close TTables & TQueries

[Alister Christie]

If the data in the lookup's is static, I'd connect a TClientDataSet to a 
TDataSetProvieder which connects to your table.  This will mean that you 
only open the tables briefly.

Alister Christie
Computers for People
Ph: 04 471 1849 Fax: 04 471 1266
http://www.salespartner.co.nz
Follow us on Twitter http://twitter.com/salespartner
PO Box 13085
Johnsonville
Wellington


On 12/02/2012 12:21 a.m., Charlie wrote:
> I'm using CodeGear 2007 with dBase tables.
> On my order form which is actually on two tabsheets (one has fields
> which are for the order table and the second tabsheet has fields which
> are for the order detail table) I have several TDBLookupCombo controls.
> For the lookup to occur the lookup table has to be 'not closed'.
> The 'order' form is called from the program's main form.
> My question is should I open these tables when the order form is created
> or open these tables when either of the tabsheets are clicked on?
> Secondly, when and how should these tables be closed?
> Thank you,
> Charlie
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at listserver.123.net.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
>
>