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
17/04/2004 11:13:26
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00895276
Message ID:
00895826
Views:
25
By specifying the DBC, you cause the query to run. By not specifying the DBC, you are referencing the cursor. I'll bet it's faster now too.

>Hi Mike
>
>>Try this instead...
>>
>>select ... FROM DBF(lcVN) where !deleted()
>
>Wow, what happened? Just removing the DBC name made it to work.
>
>Though I am sorry the FROM DBF(lcVN) did not work (in this case atleast), but this did FROM (lcVN) instead of FROM (THIS.cDBCName + "!" + lcVN)
>
>Thanks a lot, but what can be the explanation between the two.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform