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.
Daniel Bonesana — — source: Informix-list mailing list archive (1991-1998)
I need help with a query that stoped working when ported from Informix 7.12
to 7.30UC7
The query is:
select desc_deleg
from oasisadm.delegaciones
where cod_financ = :cod_financ
and trim (cod_deleg) = trim (:cod_deleg)
the query is part of a DELPHI 2.0 application connecting via ODBC to the
database once 7.12 now 7.30
and using INFORMIX-CLI 2.5 dirver
The error message I get is:
Error:
Key violation. [INTERSOLV][ODBC Informix driver][Informix]Procedure (trim)
not found.
The same application retrieves the data when conneted to the old database
Thank you for any help you can give me
Daniel Bonesana
Your privacy choices
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.