> I saw your answer in 'deadlock' in forum, so I hope, you can help me:)
> I am working on site statistics application in php and firebird
> database. But I still have deadlock message, and I don't know how to
> change transactions more:)
> I need a transaction, which will wait until other finish (either other
> will commit, or rollback) with no error, and which will work with
> up-to-date values in tables, so I will not loose visitors in
> statistics:)
>
> Now I use
> ibase_trans(IBASE_WRITE|IBASE_COMMITTED|IBASE_REC_NO_VERSION|IBASE
> _WAIT,$dbhi
> );
> Can you please help me?
>
> Many thanks,
> Slavo

here's a stab in the dark... I think you are trying to update records where
the more correct design would be to insert session records. no deadlock
would hinder you and you can aggregate sessionIDs by trigger or by some
other cleanup/summarise function
Alan