Error Illegal attempt to convert to text/byte with Informix

General discussion forum about all databases other than SqlBase.
ukoegler

Error Illegal attempt to convert to text/byte with Informix

Post by ukoegler » 23 Apr 2010, 14:23

After migrating to TD 5.2 SP1 there is the following error by executing the Statements like :

Call SqlPrepare( hSql, ' UPDATE einstellungen SET
color_focus = :nFocusfarbe ,
color_back = :nHintergrundfarbe ,
play_sound = :bPLAY_SOUND,
play_system_sound = :bPLAY_SYSTEM_SOUND ,
vl_timefrom = :nVorlageTIMEFROM,
vl_wann = :nVorlageWANN ,
vl_delete = :nVorlageDELETE ,
sch_select = :bVorlageSchSelect,
vorblenden = :bVorblenden,
mail_signatur = :strSignatur,
sel_wrk_nr = :nSelWrkNr,
timer_wv = :bTimerWV,
wf_datum = :dfWFDatum,
wf_prjnr = :nWFPrjNr,
wf_sort = :nWFSort,
wf_offen = :bWFOffen,
wf_akt_bearb = :strWFAktBearbeiter
WHERE dbuser = :SqlUserOwner ' )
Call SqlSetLongBindDatatype( 10, 22 )
Call SqlExecute( hSql )

Illegal attempt to convert Text/Byte blob type.

This error occurs by every Statement wich updates/inserts Text Columns


Database is Informix 10.0.FC4
Client SDK 3.50.TC6DE

Jeff Luther

Re: Error Illegal attempt to convert to text/byte with Informix

Post by Jeff Luther » 23 Apr 2010, 23:35

It is considered bad form to double post your issues. I've already responded to this elsewhere. Do NOT post in > 1 place. Thanks.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 5 guests