TD-17512: INFORMIX-INS/UPD fail on char when logging on

Post found bugs and possible workarounds.
nfg

TD-17512: INFORMIX-INS/UPD fail on char when logging on

Post by nfg » 19 Mar 2012, 13:43

The conditions:

TD 6.0 SP5
Informix data base 11.70, configured for Unicode (en_us.utf8)
DB table with some char fields and some numeric fields

fields "geldart_id" and "lizenz_id" of the DB table "geldart" are numeric fields, fields "geldart_txt" and "geldart_short" are char fields (size 60 resp. size 10).

"nGeldartId" and "nLizenzId" are local variables of type Number, "strGeldartTxt" and "strGeldartShort" are local variables of type String.


The following INSERT and UPDATE commands work properly when logging is disabled:

INSERT INTO geldart (geldart_id, geldart_txt, geldart_short, lizenz_id) VALUES (:nGeldartId, :strGeldartTxt, :strGeldartShort, :nLizenzId)

UPDATE geldart SET geldart_txt = :strGeldartTxt, geldart_short = :strGeldartShort, lizenz_id = :nLizenzId WHERE geldart_id = :nGeldartId


==> If however logging is enabled the numeric fields in the DB table are set, but the char fields are empty after the INSERT or UPDATE (even if containing text before the UPDATE). SqlPrepare and SqlExecute return TRUE.


Logging is enabled by the following entries in sql.ini:

[win32client.ifx32]
log=D:\HiMed\Log_Test\ifx32.log


Logging is a "MUST HAVE" for our application.


See the attached log file of a CONNECT, INSERT, COMMIT and DISCONNECT. What does the entry [ERROR] 196 mean?
You do not have the required permissions to view the files attached to this post.
Last edited by nfg on 23 Mar 2012, 07:11, edited 1 time in total.

nfg

Re: TD-17512: INFORMIX-INS/UPD fail on char when logging on

Post by nfg » 19 Mar 2012, 15:38

Additional info:

When not started from the IDE of TD 6.0 but as an EXE, the app crashes (terminates itself) without any error message on the CONNECT to the DB when logging is on.

nfg

Re: TD-17512: INFORMIX-INS/UPD fail on char when logging on

Post by nfg » 27 Mar 2012, 07:58

Is there any opinion to my problem? :?:

Jeff Luther

Re: TD-17512: INFORMIX-INS/UPD fail on char when logging on

Post by Jeff Luther » 30 Mar 2012, 00:13

Better than an opinion, I have added TD defect TD-17512 for this issue, nfg.

nfg

Re: TD-17512: INFORMIX-INS/UPD fail on char when logging on

Post by nfg » 30 Mar 2012, 07:09

Thank you, Jeff!

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests