Best practice for Data Component management in multiform app
lazarus / 16-Databases

----------------------------------------------------------------------
seaton · 2011-01-24 12:40

G'Day one and all,

I'm using the zeos database components and SQLite in a multiform
sqlite database app, however I'm finding that the management of them
in all the forms is becoming a chore, especially setting the database
location in each TzConnection.

Each form has a TZConnection, then a number of TzTables, and
DataSources.  Am I better off setting a single TzConnection on the
main form then keeping the TzTables and datasources on the relevant
forms?

Regards,

Stephen...

----------------------------------------------------------------------
garlar27 · 2011-01-24 14:17

You can use a TDataModule to contain your Connection, and some tables,
querys or what ever you may need.

You can add a TDataModule by choosing menu: "File/New.." then pick
"Data Module" from the "Module" branch and click OK

----------------------------------------------------------------------
seaton · 2011-01-25 03:36

Thanks for that, this will definately resolve the problem. As a newb I
didn't know they existed   Many thanks.