Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Important
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00549630
Message ID:
00549635
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform