Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to sort grid box record when clicking the header?
Message
From
07/02/1999 12:34:14
 
 
To
07/02/1999 08:11:07
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00184218
Message ID:
00184859
Views:
14
>>I admit I'm a laggard here, not using p-views. Each query, in the case in point, might refer to different source tables with wildly different search conditions. You can set up a p-view using &sqlstr though can't you?
>
>You can try. I didn't :)
>
>Actually, trying that animal out may solve some mysteries on the issue of views - like "is the SQL string of a view re-evaluated each time or is it stored compiled" and "if compiled, does an embedded macro force re-evaluation at requery"...

I think you will find that the SQL is compiled and run when the view is queried- this is why a view's SQL property is readonly. The only action that can give this property a new value is CREATE SQL VIEW. This is just conjecture...
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform