DELETED EVENT IN GRID

[BRADLEY21]

I am using a grid that is reading a view set to optimistic buffering.

I want to warn the user that the record will be deleted when the delete column of the grid is tagged.

However I do not know how to programatically un-delete the marked grid. I tried recall but it does not work. The ideal solution would be for the user to get a messagebox that can loop them out of the delete action before it happens.

Any ideas.

 

[Mike Gagnon]

ejd

You would need to undelete the actual record, nothing to do with the grid.
Record the record number
LOCAL rec
store recno() to rec
SET DELETED OFF
SELECT myTable
goto rec
RECALL
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[danceman]

in design mode. right click the grid and select properties. in the properties box find the DeleteMark Property and set to .f. Attitude is Everything

 

[BRADLEY21]

Thanks Mike but my database is Oracle. I was hoping to trap the delete before it can happen.

I think my only solution is to create my own column and create a delete function in the click event.

 

[danceman]

if you want to bring back a buffered record, use tablerevert function. check the help file to use it correctly for your applicaton.

my earyler posting was to remove the ability for the user to delte a record by the delte tag. Attitude is Everything

 

[Mike Gagnon]

EJD

Thanks Mike but my database is Oracle. I was hoping to trap the delete before it can happen.

I think my only solution is to create my own column and create a delete function in the click event.

I think as danceman suggested, your best bet is to set the deletemark to .f. on the grid and use a command button to allow the user to delete records, and do the checking and confirming, and once every confirmation is done, set deletemark to .t. and allow the user to delete the record.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first