I have a form with 6 cursoradapter objects placed in dataenvironment.
The cursoradapters have to be connected through ODBC to six SQlServer tables. Using cursoradapter buider it seems that it is very easy to be done. But reality is not so bright.
When all cursoradapters have UseDEDataSource = FALSE all cursors are filled
(in view window one can see all six used cursors)
When all cursoradapters have UseDEDataSource = TRUE only first three are filled (in view window one can see only three used cursors)
What is the reason of such behavior ?
Should each cursoradapter object have its private connection handle ?
Shoud we check if cursoradapters are filled ?
Thanks in advance.