I need an explanation for the following.
I was using this code to insert into a table:
Table.FieldByName('One').AsInteger = X;
same code repeated for second table
This is a simplified example but still gives the general idea. The application using this code worked for several months. Then started hanging on the Table.Post line of first table. Sometimes, the data would post and sometimes in would not (usually not). It always caused the application to stop responding and usually the machine had to be restarted.
The problem was solved using:
Of the two tables, the first had about 167 records and the second, 2000. What caused this? Has anyone else ran into the same problem? The points will go to the person who tells me what caused the problem (and provides enough details to support their answer).
Using Delphi 5 Enterprise, Windows 98 machines, SQL Server 6.5, NT server.