Property commands are only good to affect controls in a form.
The OPEN cursor RESET command will cause the cursor to be re-evaluated, and
I use that all the time, but usually it's when I'm resetting a nested inner
cursor depending on the new values of the outer cursor. Don't know if
it'll work for you. Here's an example:
DECLARE curs1 CURSOR FOR SELECT columns FROM table WHERE ... ORDER BY ....
DECLARE curs2 CURSOR FOR SELECT columns FROM table WHERE ... ORDER BY ....
OPEN curs1
WHILE 1 = 1 THEN
FETCH curs1 INTO vars
IF SQLCODE = 100 THEN
BREAK
ENDIF
*( do stuff with 1st table)
OPEN curs2 RESET
WHILE 1 = 1 THEN
FETCH curs2 INTO vars
IF SQLCODE = 100 THEN
BREAK
ENDIF
*(do stuff)
ENDWHILE
ENDWHILE
Karen
> Is it possible to be in a while loop, and insert additional records into
> the table which you are reading ?
>
> When I try this, the records do get inserted at the end, but the while
> loop ends at what was the last record before the new inserted one ?
>
> Could a property command help in this situation ?
>
> Thanks
>
> JIm
