Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change order of a view
Message
From
01/04/2005 10:12:44
 
 
To
01/04/2005 09:54:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01000628
Message ID:
01000651
Views:
20
This message has been marked as the solution to the initial question of the thread.
>Right, but the problem is that the program is build on a class that needs table buffering to work well. From the moment i change the buffering status this thing starts to act strange. (even when i change it before the index an reset it afther the index)

I uses Table buffering with emptying buffer/RecordBuffer/IndexOn/Tablebuffer change,
and until now i have not found critical issues.

Of course, if you want a change of order with table buffer not empty,
you have to work very more.

>
>So i have only 2 options : one is to find a sollution to change or create an order not using index on hoping the problem will be solved or te rewrite the hole class...
>

RV don't support literal parameters, like:

SELECT * FROM db!sometable ORDER BY &?eOrder

a way can to be, to define the RV on the fly, at runtime.

>anyway thnx fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform