Dorin,
>Try SQLIDLEDISCONNECT( nHandle ) before tableupdate and after another connection was possible.
Thank you. I added this command after SQLEXEC('Start TRANSACTION') returns connection lost error. This solves the problem.
I do'nt understand "before tableupdate".
I have TABLEUPDATE() command inside transaction. If I add SQLIDLEDISCONNECT()
before TABLEUPDATE() SQLIDLEDISCONNECT() causes transaction to be rolled back since new connection is requested from backend. So it seems that it is not possible to add SQLIDLEDISCONNECT() before tableupdate if tableupdate is used in transaction.
If connection lost error is returned from TABLEUPDATE(), I think I must recommend the user to re-try the command. This causes the whole transaction to be re-executed.
Andrus