Re: Too many or too few host variables given.
On Sun, 20 Jun 2004 08:35:45 -0400, Markus Brinkb?umer wrote:
For a BLOB field IDS does not expect a string for an insert or update, but a
BLOB Descriptor. Check out the manual on how to fill in the data structure.
Art S. Kagel
> 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