SQL Server doesn't know what you are doing inside of FoxPro so issuing a BEGIN TRANSACTION there has no effect. Try setting the Transactions property to 2 for manual transactions and executing your transactios using SPT.
=SQLEXEC(1,"Begin Transaction")
* do some updates
=SQLEXEC(1,"Begin Transaction")
* do some updates
=SQLEXEC(1,"Commit Transaction")
=SQLEXEC(1,"Commit Transaction")
>please ignore first message.
>my code is like follows.
>
>begin transaction
>
>---some updates
>
>begin transaction
>
>--more updates
>
>sqlcommit(1)
>
>end transaction
>
>end transaction.
>
>my problem is when i issued sqlcommit in second transaciont level , it commits first transaction's updates also to back-end.
>
>anyone guide me where i am wrong??
>
>thanks for help.
>
>mark
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao