Dmitry ----

Do you have any fields designated as part of a Primary or Candidate key and are these fields being populated correctly? Secondly, are these fields being updated from VFP if they are being populated from VFP? Check in the view designer if updatable is checked off for those fields.



>
>Do You know, why the cursor, that based on SQL-View, buffered in "Optimistic Table" mode and
>contains no records when it created, could not be updated correctly?
>
>In details, when I add some records into that cursor and try to use TABLEUPDATE( .T. ) command,
>one new record is adding to the bottom of cursor, and it comes to many new problems, such as
>impossibility of buffer reverting, staying of uncloseable private DataSession after form releasing, etc.
>
>Such problems is taking their place to when I trying to update all records one by one.
>
>What can I do with this?
>
>Thank You, sorry for bad English.
>
>Dmitry Belyaev