Meaning of the error "Value was not prepared for Update"

[Fran=?ISO-8859-1?B?5w==?=ois Van Lerberghe]

V4RB version is 4.3
Field is a UShortField, indexed, Unique

These are the step I got it :
- Try to add a record using SQL command :
    INSERT INTO myTableName ( myUniqueFieldName ) VALUES ( 0 )
    -> Error 23503
- Update a record of the same table using class way :
    myVCursor.SomeOtherField.value = 1234
    myVCursor.UpdateRecord
    -> Error 8050E
- Retrying to update using class way : always error 8050E
- Update a record of the table using SQL way :
UPDATE myTableName SET SomeOtherFieldName = 127 WHERE myUniqueFieldName = 27
    -> no more error

As soon as I have the time I will try to reproduce with the last version and
I wil put it in Mantis (if I can reproduce).

Thank you.

François Van Lerberghe


le 18/06/13 9:21, Ivan Smahin <ivan_smahin at paradigmasoft.com> a écrit :

> 
> On Jun 17, 2013, at 1:11 PM, François Van Lerberghe <frvanlerberghe at gmail.com>
> wrote:
> 
>> Hello,
>> 
>> Tomorrox I have had error # 8050E : "Field "xxx" : value was not prepared
>> for Update".
>> This error occur after another one (# 23503 : "Attempt to insert duplicate
>> key row in object "xxx" with unique index "zzz"), resulting of an action
>> where I attemp to add a duplicate value in a field having unique attribute
>> set. Following this first error, I have tried to update a record in the
>> table and got this second (# 8050E).
>> 
>> Can someone explain me the exact meaning of that second error and what I can
>> do to solve/avoid it.
>> 
> 
> 
> Obviously, after failed "add record" internal field state prevents using
> current values for "update".
> But I can not reproduce it in the test.
> Can you tell me how do you get it in detail, table structure and so on?
> V4RB version you are using?
> 
> As workaround you should repeat your FillRecord step - just before calling
> Update.