Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE(2,.T.) leaves records that are not updated
Message
From
08/05/2001 21:11:56
 
 
To
07/05/2001 08:18:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00500580
Message ID:
00505080
Views:
34
>>>I'm updating a view (buffering=5), even go top, the TABLEUPDATE(2,.T.) returns .t., but trying to change buffering results in an error.
>>>
>>>What am I doing wrong, or how do I get it right?
>>
>>Check the return value of TABLEUPDATE, if it returns .F., use AERROR to see why.
>>
>>If it returns true, but it appears that some records were not updated, I would guess you have a problem with primary keys?
>
>Right you are, it's the PK.
>Now the question remains, what's the fastest way to find the offending record(s)?
>

You shouldn't have to go through all that to find duplicate PKs. Your base table should have a constraint on its PK so that duplicates are not allowed at all.

PS, the code you posted never does a GO to the next modifies record.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform