General information
Title:
Index View in buffering mode?
I am trying to implement a grid which resembles the listbox. The main feature I want is to allow user to select a few records and move the records up or down in the table. I keep a sequence number in the table to sequence the records. It works fine if I am using non-buffered view and tables. But when I use view with table buffering, VFP stops me by saying view with buffering cannot be indexed.
Can someone suggest a way to overcome this? If there is no way of indexing the view, is there any way I can reorder my items on the grid without using index?
Because I am on buffering mode, I need to do a 'COPY TO' statement to get data from the memory before I issue an SQL statement to collect the records that are flagged. Is there a better way?
This thing is taking too much of my project time and it is killing me. Please save me... I guess that's why MS never implements a moverbar-listbox that accepts input from fields.
Any help will be appreciated. Thank you.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only