Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Get View With No Data
Message
From
01/08/2001 11:49:47
 
 
To
01/08/2001 11:31:32
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538321
Message ID:
00538344
Views:
12
This message has been marked as a message which has helped to the initial question of the thread.
Hi!

I don't know if USE AGAIN will work with NODATA, just try it.
From what I know, REQUERY cannot be used until you make misterious parameter in your view like '?llNoData=.F.' and assign .T. to llNoData so result set of query is empty.

HTH.

>Hey Vlad,
>
>Ok, so if I have a view open and want to requery it to have no records then requery it again to have records, maintaining the same alias, is the following correct?
>
>
>Requery('View1') && Returns Data
>Use View1 NoData && Returns No Data
>Requery('View1') && Returns Data Again
>
>
>Does the Use affect the view for subsequent Requery? If so, can I use the Again clause or is that superfluous?
>
>Renoir
>
>>USE ...ViewName NODATA.
>>
>>Take a look to help on USE command, NODATA option.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform