[DUG] Open / Close TTables & TQueries

[Charlie]

Thank you and I will:
read this: http://www.drbob42.com/examines/examin64.htm and also search 
for "briefcase model ClientDataset" on google.

Charlie

On 2/11/2012 7:27 AM, Jackson Gomes 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?
>
> when you have data for lookups, you should keep these datasets active, 
> as you probably will use these same data again. This will minimize 
> network traffic, server load, etc...
>
> For these cases, the best solution is to use ClientDatasets, as you 
> can load the data in the ClientDataset and disconnect from the 
> database, keeping the data on the local memory.
>
> read this: http://www.drbob42.com/examines/examin64.htm and also 
> search for "briefcase model ClientDataset" on google.
>
> --
> Jackson
>
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20120211/83d4db74/attachment.html