Hi Suhas,
Donnot use VFP with:
sqlsetprop(handle,"Transactions",2)
it have a bug when you disconnect the program quit without a explicit rollback.
read:
Thread #
767979A long explain start at Message #
820367;
on messages Message #
820416,Message #
820567, Message #
820602 ...
I hope Aleksey and VFPT fixed it on VFP9,
but on Message #
820794 Aleksey write this,
According to this, current behavior SQLDisconnect() behavior is a legitimate BUG and, I assume, that it is not likely anyone relied on it. However, the fix I am thinking of is to force rollback rather than do nothing or generate an error.
and this is a error because this do
MSSQL multiapplication shared connections not usable.
Correct is do nothing, and to leave the backend to resolve the disconnection.This is correct because:
- if the Client PC power supply crash, connection is disconnected without send command.
- If SQLDISCONNECT() return a error ( net line go down ), what you can do ?
Nothing !
Fabio