Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Important
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00549630
Message ID:
00549635
Views:
15
Why not just use SCAN/ENDSCAN:
use lv_Batch_Nums
scan && if eof(), this just exits to line after endscan
   * do other stuff here
endscan
Now since you say it works if you remove the view or other tables, it sounds like you additional code is resetting the record pointer on your lv_Batch_Nums view. To be sure either provide that code as well or set a breakpoint on when RECNO('lv_Batch_Nums') changes on the debugger.

>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
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform