Hi Peter,

You don't have to use a form to try CursorAdapter, it works just fine outside of DataEnvironment.

>But I havent discovered how to don't load data to the CA (cursor), when I run the form, then it asks for a value for the SELECT command...
>
>Where in the form or CA or DE should I put a variable, so it doenst ask for the value...,
>or what should I do to pass an inital value of -1 to the variable in the CA ?

To disable automatic data loading on the form, set Form.DataEnvironment.AutoOpenTables=.F..
But be aware that if the form has controls bound to the CursorAdapter, the form may fail to load.

>...and later if I want to requery the data, where I should put the variable the variable that CA could use ?
>

To load data, call Form.DataEnvironment.OpenTables() method.

Thanks,
Aleksey Tsingauz.