Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
paul — — source: Informix-list mailing list archive (1991-1998)
Dear all
When I perform Delete SQL command for one table, I often got an error
code -240, but there are nothing useful message from "finderr" command, can
someone help!
Thanks in advance!
↪ replying to paul
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
paul wrote:
>
> Dear all
> When I perform Delete SQL command for one table, I often got an error
> code -240, but there are nothing useful message from "finderr" command, can
> someone help!
Actually the finderr for -240 is VERY helpful. It reminds you that you have
to check the ISAM error to know WHY the delete failed. If you are using
4GL for a front-end check sqlca.sqlerrd[2] if ESQL/C is you front-end check
the value of sqlca.sqlerrd[1].
Without knowing the value of the ISAM code we don't know why the delete
failed either.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.