Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert records in a view
Message
De
03/11/1999 13:23:17
 
 
À
03/11/1999 09:59:32
Marco Beuk
Innovero Software Solutions
The Hague, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00283021
Message ID:
00286309
Vues:
17
>>>No, I did not. I do check it now and it returns .F.. With aError I find out that the error 'Uniqueness of key violated' (or something like that) is the problem. When I change my index to a regular index (was primary) TableUpdate returns .T. and all new records are inserted but there Id = 0.
>>>
>>>Any idea?
>>>Marco
>>
>>How are you generating the PK in the view? Sounds like your "unique" number is not so unique after all.
>
>Yes, they are unique. As I write before when I browse the view all records have a unique PK. After a tableupdate the inserted records in the table have PK 0. It seems like the PK is not updated.

Is your primary Key marked as updatable in the view definition.
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform