Hi All, I am sorry, this is non PFC question. I have a problem about ROLLBACK command. I have two table Master and Detail. First, I update the Master table using UPDATE .. SET ... WHERE ... command and I check the return SQLCA.SQLCode, If update process failed, the transaction will be rollback. Then, I update the Detail table using UPDATE ... SET .... WHERE CURRENT OF cursorname command. I also check then return SQLCA.SQLCode, so if update process failed, the transaction will be rollback too. I this point, I got the problem. When update process failed, the transaction is not rollback. Is ROLLBACK command can't be use in UPDATE ... SET .... WHERE CURRENT OF cursorname command ? How Can I rollback the transaction when I update a data with UPDATE ... SET .... WHERE CURRENT OF cursorname command ? Thank's in advance, -Rendy ---------------------------- Rendy Theixar PT. Surabaya Agung Industri Pulp & Paper Tbk Email : [EMAIL PROTECTED] URL : http://www.suryakertas.com > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
