>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