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