Re: Too many or too few host variables given.
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)