Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get no records when trying to exclude deleted records
Message
From
11/04/2001 03:59:27
Fred Taylor
Phoenix, Arizona, United States
 
 
To
10/04/2001 22:24:04
Claude Goldman
Brown University
Providence, Rhode Island, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Get no records when trying to exclude deleted records
Miscellaneous
Thread ID:
00494168
Message ID:
00494323
Views:
25
>Thanks to all who responded. I did realize that SQL select did not honor DELETED(). Will look at seting of deleted.
>

SQL select does honor DELETED(), just not when multiple tables are involved or if an alias is specified.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform