>Hi,
>
>The default value for CursorAdapter.UseDEDataSource property is .F. , it means that 15 Cursors will create 15 connections because their Init method does it from my base class.
>
>What is the best practice these days? To create and use the Form's DataSource or to create an independent connection for every CA ?
>
>Thanks.
>Juan

Juan

Firstly to open/close connections the whole time is not good. Takes too much time & resources. Better to establish a connection and use that for the life of your program.

That way it does not really matter how you open the CA's, they will still all use the same connection. As far as I am concerned, I use the DE.