Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Location
    Graz / AUT
    Posts
    9

    Red face Unanswered: sometimes UPDATE is not working ?!?

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Erik,

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

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •