Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append/Add Record in View - Blank key field in table
Message
De
23/07/1999 12:25:10
 
 
À
23/07/1999 11:28:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00245336
Message ID:
00245381
Vues:
25
>(.t.) ". At this point the local view source table (People) is updated with all fields from the local view except for the key field (people_id). The key field (people_id) is correct in the local view but blank in the source table.
>
>This of course causes an update conflict when the second new reord is added, because both have blank keys.
>
>I made the key field updatable in the local view. This does not help. Local view has "Send SQL updates" checked, SQL where clause includes "SQL Key fields only" and Update using "SQL Update".
>
>I feel this is just a small thing I have overlooked, but I cannot pin down what it is.

Is this a multi-table view? You might want to generate and look at the view code to see if anything unusual is happening.

Dan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform