Examples of a code for VFP 8.0 (or later) uses of the several CursorAdapter classes containing parameterized SQL-SELECTs to MS SQL Server through ADO, in Dataenvironment forms:

- In the form of frmcaadochild1.scx one connection with a server is used to serve all CA, included in DE. It is constructed on the basis of the code generated by builder with flag 'Use DataEnvironment data source' for all CA. This variant is "Experimental" and it is not necessary to use in real work since it though works directly as it is written, however has a problem that on closing of the form reference DE.DataSource does not destroy :-( It it is possible to see, if at the form to set DataSession=2... on closing the form it is had instance (not destroyed) used PDS.
- In frmcaadochild2.scx everyone CA from DE has own connection with a server
- frmcaadochild3.scx it is the altered frmcaadochild2.scx under work on only one connection to server.
- frmcaadochild4.scx other variant of reprogramming of the form frmcaadochild2.scx, under work on one connection to server.

Best regards.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael Drozdov, ICS Soft, Perm, Russia
My Page: http://vfpdev.narod.ru/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
