Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Showing deleted records in grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00220886
Message ID:
00221293
Views:
11
>In some complex grids I would like to give users the possibility checking wich records have been deleted before commiting the changes. Is there a way of doing it without using to set deleted on? I would like something like setting DynamicFontStrikeThru to .T. when the record is deleted. The way I have it now works but the record disappears as soon as I move to a different row.

Not sure if anyone mentioned this idea, but what I do is:

1) Use view to hold data before updating base table
2) do an SQL into cursor on the view with SET DELE OFF and a flag for deleted
3) Put the cursor into the grid, use dynamicfontstrikethru for deleted

If you need to allow users to change their mind on deleted records in this grid, that can be done also...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform