Re: Too many or too few host variables given.
Try:
EXECUTE PROCEDURE ifx_allow_newline ( 'T' );before.
Uzytkownik "Laurent" <collignon.l@wanadoo.fr> napisal w wiadomosci
news:40D70E2E.2010403@wanadoo.fr...
> Markus Brinkb?umer a 'crit:
>
> >Hello Newsgroup,
> >
> >I've got a problem with an little update-statement.
> >I'm using Informix Dynamic Server 9.40 TC2 on Windows 2000 with CLI
> >Version 3.81.
> >
> >The statement looks like this:
> >
> >UPDATE csg_tab_doku SET dokumentation = 'ich bin ein test test test',> >dokumentation_rtf =
'{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1031{\\fonttbl{\\f0\\fnil\\fcharset0
> >Tahoma;}}
> >{\\colortbl ;\\red255\\green0\\blue0;}
> >\\viewkind4\\uc1\\pard\\f0\\fs20 ich bin ein \\b test \\b0 test \\cf1 test\\cf0
> >\\par }', user_update = 'informix', datum_update = '20.06.2004' WHERE
> >tabname = 'cs_teile' AND spaltenname = 'artikel_key'
> >
> >The statement looks right for me. The fields dokumentation and
> >dokumentation_rtf are blob-data-types (text-fields). When I try to
> >execute this statement I will get the following error:
> >
> >Error-No.....: -254
> >Source.......: ODBC
> >Description..: 07001: [Informix][Informix ODBC Driver][Informix]Too
> >many or too few host variables given.
> >SQL-State....: 07001
> >RetCode......: -1
> >
> >It works when I set dokumentation_rtf = ''.
> >
> >I have looked at the Find Error-Tool - but it don't helps me much.
> >What's wrong with my statement. Are there any reserved informix-words
> >in my statement?
> >
> >
> >Thank you for your help.
> >
> >Greetz
> >
> >Markus
> >
> >
>
> Not sure but the '\\' is often an escape character so you may try to
> double it in your string
> You can also replace single quote by double (ascii 34)
>