General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Does the SET DELETED setting not affect views in a dbc?
>
>I have a view that does not return DELETED records at all, yet I can write a SELECT statement in the Command Window, and I get the desired effect of the SET DELETED setting.
(First off, I did not point out that view is running against local dbf tables)
Well, I think I see what is going on... The with "set deleted on", the records do not appear in the results, and with "set deleted off", the deleted records do appear in the results; it's just that I did not see that little black box beside the record in the Browse window, so you cannot tell that the record is deleted.
Looks like I just need to add an int field to use as a deleted marker, as this will surely cause me problems when I convert my app over to a SQL Server back end.
Previous
Next
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