I am using temporary indexes(.idx) to reorder a table in a grid on HeaderClick. On another page of the form the current record can be updated. All indexes are released and the .idx files deleted before attempting a TableUpdate command. However, a "Table has one or more non-structural indexes open. Please close them and retry the Begin Transaction" is returned from one of the database stored procedures. Buffering is type 3 - optimistic row. Ignoring the error continues execution as desired.
I understand using temporary indexes in VFP is not the best idea. Should I forget about them entirely, or is there a way around this problem?
Any and all suggestions gratefully received.
Ben