hi,

i have following problem with this code on a new server:

...
LET p.id = 0 # is INTEGER
LET p.unid = 0 # is a SERIAL

INSERT INTO mytable VALUES (p.*)

LET s_id = SQLCA.SQLERRD[2]

UPDATE mytable SET id = unid WHERE unid = s_id

the code above is working correctly about 2 - 4 times (in a loop), after that
the UPDATE makes nothing (without any messages or abort !!!) so that
"id" is always 0 !!!

my system: IDS 7.31.UC4 on SCO OpenServer 6 (it was working fine with
OpenServer 5.0.5)

does anyone have similar problems (perhaps solved) ?
any hints for me ?
PLEASE HELP !!!


Thanks
Erik

Hi Erik,

You work with logging database, please test the transaction process.
I think that the problem is the handle of transaction.

Gustavo.