Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Occasionally hanging on a table with buffering
Message
From
19/01/2008 11:23:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
19/01/2008 11:14:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01283131
Message ID:
01283274
Views:
11
>Hilmar --
>
>Now, another related problem ...
>
>My users select the record they are to edit from clicking on a grid. Previously, they were able to sort the grid by clicking on the column heading. Now, that fails, because apparently its not possible to create an index on a buffered table (I can see the internal problems that would cause).
>
>As for the mechanics -- what you described is what I assumed. I just have trouble understanding why it would make a difference whether its in LOAD or INIT. (If it could have been done it INIT, then it would be possible to pass parameters indicating, for instance, what file to edit.)
>
>Jim

You can index and then set the buffering. Or have buffering 3, index and then 5. It only doesn't let you index buffering is at table level.

Init would be just fine.

What I do is to use an SQL cursor for grid and not the actual table itself (namely the LocatorGrid class from FoxyClasses). In its AfterRowColChange it simply seeks or locates the underlying table's record and refresh the controls.

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform