Scenario :
I have a local view in a grid - when I click on a column header a text box comes forward to enter the value to search for. This creates a temp index and puts the column in the correct order, I can then do a NEAR ON and SEEK for the value input into the text box.
Problem :
Previously, this has worked fine, now at version 6.0 I get an error message "Command cannot be issued on a table with cursors in table buffering mode." when I attempt to create the index. I am using the Optimistic buffering mode.
Solution?
I would appreciate any help with this or an alternative solution that will emulate the same behaviour.