Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COUNT caused Uniqueness of Index Violation?
Message
De
29/10/1997 03:21:15
 
 
À
29/10/1997 01:04:15
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapour
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00057154
Message ID:
00057165
Vues:
32
>I have master-detail form with both master and detail tables on table buffered mode. Both of them are put on grid. After I issue a COUNT TO ... (or CALCULATE XXX()) on the child table and when I start appending new record, I will get Uniqueness of Index Violation on my child table's primary key. The primary key is generated from NEWID function (tastrade) and I can't imagine how it can go wrong.
>
>Is it a bug in VFP? Anyone has encountered such thing before? I suspect having two table-buffered grids will cause such problem.
>
>Any opinion?
>
>Thanks in advance.

Hi Tai,
I don't know if I got the problem , but why don't you use an Insert SQL statement instead of append ?
I think it will give you no problem.
HTH
Alessio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform