Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5 - REQUERY() a view for a given SELECT no. of recs
Message
From
16/04/2004 13:09:21
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00895276
Message ID:
00895626
Views:
26
This message has been marked as the solution to the initial question of the thread.
>
>I already have it as follows:
>
SELECT "R" + STR(&lcID.) AS iID, &lcText. AS cName ;
>	FROM (THIS.cDBCName + "!" + lcVN) ;
>	WHERE !DELETED() AND EMPTY(&lcPID.) ;
>	ORDER BY &lcOrder. ;
>	INTO CURSOR tQuery
>
Try this instead...

select ... FROM DBF(lcVN) where !deleted()
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform