save-letter-on-server error

Discussion in 'Bugs & Issues' started by Graham, Mar 20, 2007.

  1. Graham

    Graham Developer Staff Member

    make object! [
    code: 329
    type: 'script
    id: 'bad-bad
    arg1: "ODBC"
    arg2: {violation of PRIMARY or UNIQUE KEY constraint "INTEG_337" on table "REFERRALS"}
    arg3: none

    near: [insert db-port [{insert into REFERRALS (patient, doctor,
    subject, md5, letter, ltype) values (?, ?, ?, ?, ?, ?)} patient doctor
    copy/part subject 120 crc data ltype]
    return reduce
    ]
    where: 'save-letter-on-server
    ]

    This was sent by feedback to me just now.

    It means that the letter can not be saved *again* as it already exists.

    There is supposed to be a check to see if the letter exists before it tries to save it .. so not sure why this error should occur.

Share This Page