Re: CAN ANYONE TELL ME HOW TO USING TRANSACTION, ROLLBACK AND COMMIT

From: Ken <ken_at_not1.demon.co.uk>
Date: Sat, 1 May 1999 00:00:11 +0100
Message-ID: <925513042.18395.0.nnrp-12.d4e4a6b7@news.demon.co.uk>

UPDATE cih
SET CIH_FLAG = '2'; 200 rows effected.

"That's right so i;ll write it the database"

COMMIT; Done....

What happened there was creating a Logical Unit of Work (TRANSACTION) and then COMMITing the change fully to the D/B

*~~~~~~~~~~~~~~~*
* Ken                       *
* ICQ 34477742       *
* not1.demon.co.uk  *
*~~~~~~~~~~~~~~~*

syho wrote in message ...
>CAN ANYONE TELL ME HOW TO USING TRANSACTION, ROLLBACK AND COMMIT
>
>
Received on Fri Apr 30 1999 - 18:00:11 CDT