>>hi BOb,
>>
>>Disconnect is just an example.
>>Suppose The lan goes down ??
>
>If the server looses the connection it will rollback.
>
>>The server MUST NOT commit the transaction unless a commit is recived but here there seems to a problem.
>
>Commit was received, because it was sent by the SQLDisc(). Perhaps that shouldn't happen, but now that you know about it, it's not a big issue.
>
>I would recommend explicitly coding all SQLCommit() and SQLRollback().
>
>BOb

hi BOb,
No big issue now. I can sleep better. Thanx a lot.

Suhashegde