I had all sorts of wierd things happen with my view when I added records, and it turned out to be caused by the APPEND BLANK. If you're using that, use INSERT INTO instead.

-Michelle


>Hi all.
>
>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