Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subquery with Deleted() does not work?
Message
From
15/09/2009 09:35:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Subquery with Deleted() does not work?
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01424502
Message ID:
01424502
Views:
111
This query does not return any results, but I know the temp cursor has deleted records that are in the real table.
 Select * from JobItems where ipkey in (Select ipkey From csrTempJobItems Where Deleted()=.T.)
If I run the subquery by itself, I do get the desired results for the subquery, so I do not understand why it does not work in the full query shown above:
 Select ipkey From csrTempJobItems Where Deleted()=.T.
Next
Reply
Map
View

Click here to load this message in the networking platform