Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery, Index and Transaction
Message
From
20/02/2002 07:23:05
 
 
To
20/02/2002 06:55:39
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00622396
Message ID:
00622468
Views:
36
Hi!

Then use thisform.SetAll("lEventSwitchOffSorting",.F.). Form will cascade assignment to all controls on the form. When Grid Saver is found, it will clear its values. This approach is good for frameowrks like yours ;) this require, however, to have all forms have that property too for case form does not contains grids.

Of course, you can use CDX() function to check for non-structural indexes. Just check if CDX(1) returnes the same file name as a table name (DBF()). When not the same - index is non structural. When the same, check CDX(2) - if it returns some file, non structural indexes also exist and opened.

Just check the help on CDX() function.

HTH.

>>Hi!
>>
>>Just call the grid property setting by SetAll as in the sample in the article, and SortGrid will clear non structural indexes for you. Just Grid.SetAll("lEventSwitchOffSorting",.T.) before BEGIN TRANSACTION. To restore the sorting as it was before transaction, use Grid.SetAll("lEventSwitchOffSorting",.F.). This is predicted in a SortGrid, so SortGrid will do all this for you by a single command. Let me know if this works.
>
>Vlad,
>This would be a way. But the method using TRANSACTION is far below in class hierarchy. This method know's nothing about grid's. Also there may be other Tags.
>
>Agnes
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