Thanks for you help it was because

I was setting the sqlda->sqlvar[i].sqldata to NULL and not setting
qlda->sqlvar[i].sqllen to 0.

Nina

--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov"
<SD@t...> wrote:

> On 20 Aug 2004 at 8:07, blahclayton wrote:
>
> >sorry, the errors you have pointed out were errors in the message

not

> >in the code so it still doesn't work!!!
>
> "If program doesn't work, it has errors. Find them and fix!" (c)
> me. :-)
>
> > char* text = NULL;
> > for(unsigned int i = 0; i < nSize; i++)
> > {
> > short nullid = -1;
>
> I hope you understand that this variable does not exists after
> loop?
>
> > sqlda->sqlvar[i].sqldata = text;
> > sqlda->sqlvar[i].sqltype = SQL_TEXT;
> > sqlda->sqlvar[i].sqlind = &nullid;
> > }
>
> So, sqlind now is pointing to garbage.
>
> SY, Dimitry Sibiryakov.