rcandeo
Well Known Member
I have a loop like this one:
select F56001
fetch next F56001
While status = success
fetch single F56001 (another key)
If status = success
update F56001
else
insert F56001
end if
fetch next F56001
end while
My report is not working as expected, I think the reason is the fetch single with another key in the middlee of the while.
Does someone can help me with a tip to repointer my key?
I´ve tried to put a new select before the last fetch next but it is in loop because of that.
select F56001
fetch next F56001
While status = success
fetch single F56001 (another key)
If status = success
update F56001
else
insert F56001
end if
fetch next F56001
end while
My report is not working as expected, I think the reason is the fetch single with another key in the middlee of the while.
Does someone can help me with a tip to repointer my key?
I´ve tried to put a new select before the last fetch next but it is in loop because of that.