General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have created a procedure in which I created a View that selects only one field(Batch_num) from table Claims say lv_Batch_nums. To go through each record of lv_Batch_nums i used a for loop like
use lv_Batch_nums
if reccount() > 0
for cnt = 1 to reccount() step 1
goto cnt
* Here I created another view and worked with other tables.
endfor
endif
I found that the for loop keeps me on the same record in lv_Batch_nums. It keeps me on the very first record thoughout the loop. If I remove the view or other tables i am working within the loop, then it works fine.
Any help
Thanks
Bharat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only