>Why would one do this?
>
>Scenario:
>
>Data is pulled from SQL server into cursor for an individual
>Cursor is then buffered
>Cursor is updated from input form (there is no update/commit on the cursor, just replaces)
>SQL server is updated from cursor.
>Data is repulled from SQL server into cursor for the same individual
>
>We have instances where (at least) one field is not making it 'back' from SQL server and is causing issues further downstream in the process and, of course, it's only happening on occasion.


Dorris,

A possible scenario

Entering a value into a textbox bound to a field of the cursor
The textbox does not lose the focus ( ie, the controlsource is not updated yet) eg by clicking on a toobarbutton
Update Sqlserver with cursor


Update : and how do you update sql server with the data in the cursor ?