Open QRY statement

[Karan]

All,
I like to know , if I have to use the GET NEXT QRYNAME to fetch next record, in my error
handling statement much before the actual GET NEXt STATEMENT .


If my loop begins with

Open qry QRYNAME < FOR EACH table..where cond>

test:
DO WHILE AVAILABLE <table) TRANSACTION:
.
. if error then
do:
run logerror
<should I mention the get next qryname here, does progress
not doit implicit >
undo test, next test.
.end.
.
.
get next QRYNAME
end. /* DO WHILE*/

Will “undo test, next test” will not fetch the next record automatically ?

Thanks in advance
++

 

[bulklodd]

Will “undo test, next test” will not fetch the next record automatically ?

It's true therefore you should do it explicitly

IF ERROR THEN
DO:
   GET NEXT QRYNAME.
   UNDO TEST, NEXT TEST.
END.