Hi!
I'm having a problem. I'm getting the following error:
-245, Could not position within a file via an index
with the corresponding ISAM error
-143, A deadlock has occured. Rollback the current transaction and
retry it.
I'm using Informix OnLine and the statement which fails goes as follows:
SELECT MAX(seqno) maxseqno FROM tablename WHERE column=value;
One point to consider is that there are no rows satisfing the condition, I
expect to get a 0 in return. As my application is in a multiuser environment
and we use transaction control (begin-commit-rollback) I have an idea that the
problem may be due to attempt of multiple access on that row/table.
Does anyone have any clues ?
If You don't have any suggestions could You at least point out what the actual
problem is?
Thanks for any advice,
Magnus Lundgren
Stockholm
PS! On subsequent calls with the same query I will get error -245, "Could not do
an indexed read to get the next row", but i presume that if I solve the first
error I will get rid of the following one...