They only work against VFP data, not SQL Server.
>Dear Naomi Nosonovsky
>
>According to my knowledge, BEGIN TRANSACTION/END TRANSACTION is a set of codes which passes commands. It works like electrical switch ON or OFF. If TRANSACTION is completed then all commands in BEGIN TRANSACTION/END TRANSACTION works others wise fail or rollback.
>
>If connection fails with server during BEGIN TRANSACTION/END TRANSACTION then all is rollback like Insert,delete etc.
>
>
>So I use code like this
>
>BEGIN TRANSACTION
>
>Delete voucher
>Insert voucher
>
>END TRANSACTION
>
>
>If I do not use BEGIN TRANSACTION/END TRANSACTION and powere goes after DELETE VOUCHER then Insert commad will not run.
>In case of useing BEGIN TRANSACTION/END TRANSACTION, powers goes on connection fails then all will be rollback.
>
>May be my knowledge about BEGIN TRANSACTION/END TRANSACTION is wrong. If yes then please help how to modify my codes in a better way.
>
>Thanks in advacne
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer