Grid Index Out Of Range Error???

[EricDraven]

My system has been working fine except some users have complained about speed over the network using machines slower than mine. To remedy this, instead of using filters and the locate function, I introduced indexes on a couple of tables and used the findkey function. Now I am getting the error "Grid Index Out Of Range" at various points in the program. I have used the debugger to step through my code and can see that this is happening when I am trying to append to the indexed table. If anyone has come across this error before, I would greatly appreciate the feedback as it is pretty urgent and needs fixing ASAP.

Thanks in advance Arte Et Labore

 

[towerbase]

Can you give us some more details?

Which version of Delphi?

Is this client server?

What kind of DBMS are you using (Paradox, SQL Server etc)?

Are other applications/users updating the tables without using the indexes?

Andrew

 

[EricDraven]

Its Delphi5, client server and is using DBase Tables. The problem seems to have stopped in a most peculiar manner. The error occurs when trying to append and also when using FindKey after the initial error. However, placing a call to the first record (Table1.First) eliminates the error. Change this first call to a last call, and the error occurs. Im still intrested to find out what could have been causing the error in the first place? Arte Et Labore