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

[Ivan Smahin]

Hi,

On Jun 18, 2013, at 4:58 PM, François Van Lerberghe <frvanlerberghe at gmail.com> wrote:

> V4RB version is 4.3

You should try at least 4.9. Judging on the source code this issue was fixed there.

> 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

So you do "update" against some cursor - not a regular table.
Is there myUniqueFieldName?
And how do you choose "position" to be updated there?

> - 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).
> 


It would be very helpful - thank you in advance.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com