Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Deleted() in SQL
Message
From
17/08/1999 11:01:21
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254376
Message ID:
00254534
Views:
27
>>>Bottom line, I was just making sure I had not overlooked some obvious error in my syntax. However, I still see no reason why this should not work. I am going to try a more creative way later tonight.
>>
>>Let me know if you figurew out a way to do it. I blew most of an afternoon trying to get it to work...
>
>This was working on some of your stuff, and not my question, right? I will post results of what I try. I hate work-arounds.

The only way I know that this works dependably, is with SET DELETE OFF, to still get only not deleted records from a single table with WHERE DELETED() = .F.. Any time there was more than one table involved, who knows what you'll get.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform