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:
00500707
Views:
36
>>>I guess I'm missing something here, GetNextModified(0) returns the first modified record. You decide what to do with it. i.e. Fix the error (which you can find by doing a TableUpdate(1)) or cancel the changes with TableRevert(.F.).
>>>Then, call GetNextModified(RecNo) passing the RecNo of the record you just processed. You do this until GetNextModified() returns 0.
>>>
>>>HTH,
>>
>>Something like DO WHILE GETNEXTMODIFIED(0) # 0...
>>
>>Have a good one, and thank's
>
>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.
Bill Armbrecht
VFP MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform