Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
incrementing in vfp
Hi:
I have a free table and I need to replace a field value (called auto; its an integer)with an incremental number starting at 1.
Ithought I had a nice loop but the field does not update; neither first nor subsequent records.
My code is attached; does anybody know where I have gone wrong?
Thanks!
The messagebox was just to prove the array nCount is valid. It will be remioved in the final version.
USE "R:\data\barcode\lrbatch2.dbf" EXCLUSIVE
COPY TO ARRAY BatchC FIELDS auto
nCount = ALEN(BatchC,1)
icnt = 1
DO WHILE icnt < nCount
REPLACE auto WITH icnt
icnt = icnt +1
ENDDO
MESSAGEBOX(nCount,1)
1: 2: 3: 4: 5: 6: 7: 8: 9:
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- vfp
- Participating Experts
- 1
- Solution Grade
- A
Posted on 2009-10-21 at 01:43:07ID: 26270601
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.