Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness error
Message
 
 
To
23/07/2007 11:24:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01242809
Message ID:
01242811
Views:
13
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
Previous
Reply
Map
View

Click here to load this message in the networking platform