Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE(2,.T.) leaves records that are not updated
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00500580
Message ID:
00500749
Views:
37
>>That is not how you use GetNextModified.
>>local lnRecNo
>>lnRecNo = 0
>>lnRecNo = GetNextModified(lnRecNo, "MyTableAlias")
>>do while lnRecNo <> 0
>>   && do whatever update you need here
>>   lnRecNo = GetNextModified(lnRecNo, "MyTableAlias")
>>enddo
>
>Hi Mark,
>I believe what he coded will work if he does a TableUpdate(1) or TableRevert(.F.) on each hit.

Yes, if that was what he was doing. Somehow, I don't think that was the case. I was real confused because at one point he said he was using SPT [first reply to Hiten Kishor].
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform