General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Temporary indexes and buffering
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
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