HI Rendy!
I have never come across the problem which u faced i.e. during Update
set where current of rollback problem. Because I stopped using cursor
functions from PowerBuilder 5.0. Why don't you use datastores to create
any kind of queries and update the records and let powerbuilder handle
the cursors. All you have to do is to create a datawindow object and
attach to a datastore and set linkage service accordingly and set
parent of the datastore as the window from where in you are firing
pfc_save. You need not code the commit or rollback and let PFC handle
that part.
Hope this solves your problem.
Thanx
Bye,
Ajay
--- Rendy Theixar <[EMAIL PROTECTED]> wrote:
> 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]
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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]
