>Is there a way to handle deleted records using local views? Whenever my local views create themselves, the deleted status of the record in the table that the view is based on does not seem to remain. I would like to be able to RECALL records from within the local view, as well. Is this possible?
When you create the views, is Deleted set to on or off? I just did a test, and if Deleted is set ON, the deleted records are not displayed. With Deleted set OFF, the records display but the delete marks are blank. What I did was to assure myself what records were deleted was to add an extra field in the Select:
CREATE SQL VIEW ViewName ;
AS Select *, Deleted() as "Deleted" ;
from MyTable order by blah, blah, blah ....
I do not know of anything you can do to actually show the delete mark. But the "Deleted" column will have a logical value based on the deleted status in the original table.
HTH.
Mark McCasland
Midlothian, TX USA