i have using delphi 6 for quite some time now and it seems that errors of the past still haunt us today.
experiencing this error code when i try to create a duplicate entry of a delivery receipt transaction. one of the suggestions i got was to disable the optimization checkbox in delphi.
after doing this it unfortunately did nothing. so i searched again, it turned out that a lot of people assumed it was a problem with the database.
what i did was to trace, line by line, my code until i reach the StoredProc in question. What i did was to put a try… except outside the storedproc procedure and everything went into place.
hope this article can help somebody in the same pickle jar as me.