Hi

I have two cursors in dataenviroment with more than 200,000 records in fatherTable (cursor1).
and more records in childTable (cursor2). The form takes too long to load.

Also there is a relation in dataenvironment fatherTable.id > id.childTable. (drag and drop type, not code)

I am considering using SELECT instead of interactive cursor of my dataenvironment in order to have more
control over the amount of records loaded.

1-How (if possible) can I build a select structure to substitute the interactive cursor ?

2-Can I do this without have to rewrite the all the code that refer to the cursors in dataenvironment ?
The selects I use along the form has the same name of table.
For ex. Select fatherTable, replace field1 with "xxx"; etc.


Moises