Datasource and Dataset

[Nick Hilder]

Hi Guys
I have been getting my head into the SQLite DataSource and Dataset.
I have them successfully working.
I have an app that has a main form and then various other forms, most with
grids etc
Is it ok to have one datasource for the SQlite db and then as I create each
form just pass the ref to that datasource
I'm then placing a datasource on each form so it's accessible in the
editor., it's like a place holder.
From what I understand so far the important bit it to always have a dataset
for each grid, don't share them. Is this correct?
I've also used the Sqldataset the same way.
BTW, the SQLite support rocks, it's very fast.
Nick

[ignacio]

Nick,
Righ now I suggest yo pass the Datasource to each Datacontrol on its
OnCreate event. That way you may have only one conecction.
In the near future we will have a special Data module that it will be public
for the rest of forms.
Regards,
--
Ignacio Ortiz de Zúñiga
Xailer support / Soporte de Xailer
http://www.xailer.com
http://www.xailer.info
"Nick Hilder" <nick_n0_spam_atcapsol.com.au> escribió en el mensaje
news:[email=49ba0432@svctag-j7w3v3j....]49ba0432@svctag-j7w3v3j....[/email]
> Hi Guys
>
> I have been getting my head into the SQLite DataSource and Dataset.
>
> I have them successfully working.
>
> I have an app that has a main form and then various other forms, most with
> grids etc
>
> Is it ok to have one datasource for the SQlite db and then as I create
> each form just pass the ref to that datasource
>
> I'm then placing a datasource on each form so it's accessible in the
> editor., it's like a place holder.
>
> From what I understand so far the important bit it to always have a
> dataset for each grid, don't share them. Is this correct?
>
> I've also used the Sqldataset the same way.
>
> BTW, the SQLite support rocks, it's very fast.
>
> Nick
>
>
>
>
>
>

[ignacio]

Nick,
Righ now I suggest yo pass the Datasource to each Datacontrol on its
OnCreate event. That way you may have only one conecction.
In the near future we will have a special Data module that it will be public
for the rest of forms.
Regards,
--
Ignacio Ortiz de Zúñiga
Xailer support / Soporte de Xailer
http://www.xailer.com
http://www.xailer.info
"Nick Hilder" <nick_n0_spam_atcapsol.com.au> escribió en el mensaje
news:[email=49ba0432@svctag-j7w3v3j....]49ba0432@svctag-j7w3v3j....[/email]
> Hi Guys
>
> I have been getting my head into the SQLite DataSource and Dataset.
>
> I have them successfully working.
>
> I have an app that has a main form and then various other forms, most with
> grids etc
>
> Is it ok to have one datasource for the SQlite db and then as I create
> each form just pass the ref to that datasource
>
> I'm then placing a datasource on each form so it's accessible in the
> editor., it's like a place holder.
>
> From what I understand so far the important bit it to always have a
> dataset for each grid, don't share them. Is this correct?
>
> I've also used the Sqldataset the same way.
>
> BTW, the SQLite support rocks, it's very fast.
>
> Nick
>
>
>
>
>
>