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