General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>You need to turn on the SET DELETED before the SELECT-SQL and turn it back off after.
>
>HTH
>I have 3 table joining each other. I want to make an sql query. I use SET DELETED OFF
>>
>>I want to filter deleted records from main source table. But I donnot know how to do it. I consult to help file. It states, that it may product unpredictable result when using deleted(), but say nothing about solution.
>>How should I do it?
Dear Sylvain, I want to filter out deleted record from main source table only. The other two ones, also can contain deleted records, but data of these records must be visible in query result.
bb
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