Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using DELETED() in a query
Message
From
09/06/2006 07:15:30
Richard Candeland
Richard Candeland Software Services
Keighley, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using DELETED() in a query
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01128074
Message ID:
01128074
Views:
76
I know you should not use DELETED() in queries containing a join, but can you safely use DELETED() in a query involving only a union? e.g.
SELECT descrip, ratemult, rate_no, .T. AS isdwp ;
  FROM xdwpr INTO CURSOR dwprates WHERE NOT DELETED() ;
  UNION ALL ;
  SELECT * FROM nodwp ;
  ORDER BY 4, 1
..or is this not recommended - it seems to produce the results I expect.
Richard
Next
Reply
Map
View

Click here to load this message in the networking platform