Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLEUPDATE(2,.T.) leaves records that are not updated
Message
De
08/05/2001 21:11:56
 
 
À
07/05/2001 08:18:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00500580
Message ID:
00505080
Vues:
33
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform