>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
Yes, you can use selects (and re-select every time parameter changes) or you can use a local view with parameter.
If it's not broken, fix it until it is.
My Blog