General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I think that's where the problem may lie, you either need the filter (or SET DELETED ON) to get the expected behaviour. One way or another, you've got to stop the SQL for the view returning deleted records from the base table.
Sorry, I should have said, I have got SET DELETED ON, I just haven't got it filtered in the view.
Kev
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