Environment versions
Network:
Windows 2003 Server
>Hi everybody,
>
>We have a VFP application using SQL Server database as back-end. Although we're using SQLExec, in certain scenarios we're using technique to make SPT cursor updatable (so in essence create remote view).
>
>Now, here are two scenarios I'm thinking what will be the best way to handle.
>
>There is a search form with a grid. It displays multiple items to chose from. This form has New, Edit, Delete buttons.
>
>The form is modeless. From this form I can open an Edit Item form which is also modeless.
>
>Now I can switch back to the Grid and delete the record I'm editing. If I then try to close the application, I'll get the update conflict error in the Edit Item form and it's not properly released.
>
>One of the possible solutions to this problem may be in disabling the Delete button if there are other opened forms.
>
>However, we can have the same situation if one user has the Grid form opened, another user has Edit Item form opened and the first user deletes this item.
>
>The error I found (I was testing the first scenario) on the CLOSE DATABASES ALL line in the main program. This line is invoked after ON ERROR (resetting on error back).
>
>What would be the best way to handle such situation?
>
>Thanks in advance.
On edit form uses buffers ?
on this case you can do a tablerevert() before delete the records
or better, a tableupdate() ( this support transactions )
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only