Thanks, John for the reply.

But Trim() didn't help at all.

The TableName is 'MASTERLIBRARY' which is shorter than the 31 char than
field_name is. And, incidentally this routine is called by the very same
function 4 previous times in my program for the very same table name (along with
many other tables before this specific occurance.)

When I tried to rem out the other lines prior to this call for this table and
re-run the program, it still gave me that message. So, there seems to be
something about this particular tablename.

I tried numerous alternate ways of setting the parameter, none worked.

I tried installing FB 1.5.2 that didn't help either.

Any more suggestion from anyone?

Thank you,

Chuck Belanger

John vd Waeter wrote:

>
> Had a similar problem a while ago: if the field is defined as e.g.
> varchar(30) and you try to pass a stringvalue via parameters that
> happens to be larger than 30 charcters: error (forgot which error was
> reported). Also in IBExpert the query went fine, also in IBObjects the
> query ran without problems. Spying the traffic, I saw these programs
> trimmed the values passed to the parameters.
>
> With ZEOS database objects: error.
>
> Maybe it is not the same as your problem, but it really sounded familiar....
>
> Regards,
> John'
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 11/05/2005