Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uniqueness error
Message
 
 
À
23/07/2007 11:24:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01242809
Message ID:
01242811
Vues:
14
You may want to pack this table first (you would need to open it exclusively).

What do you use for PK in this table?

Also use just one replace command instead of three commands, e.g.

replace field1 with val1, field2 with val2, field3 with val3

If you have table rules last variation would be quicker.

Also are you using record-level buffering or no buffering?

>Hi, i have two forms.
>
>Form A:
>- Dataenvironment: tables CV and HERITAGE
>- Form A calls Form B
>- Has the picbtns class
>
>Form B:
>- Dataenvironment: tables HERITAGE
>- I'm adding a record with this code:
>
>APPEND BLANK
>WITH thisform
>	replace padre WITH .combo1.value
>	replace madre WITH .combo2.value
>	replace hijo WITH fils
>ENDWITH
>thisform.Release
>
>
>But after i return to the Form A and try to move through the records with the pictbtns class, it displays this error 5 consecutives times:
>
>FAILED TO ADD/UPDATE RECORD(S) BECAUSE OF NON UNIQUENESS
>
>How can i solve this problem?
>Thx
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform