>>Don't forget set sqllen here too.

Thanks, but another cut & paste error to make things easier to see!!!

>>SQL_TEXT+1;

Thank you this was my problem !!!

I can finally set SQL parameters to NULL in Linux & Windows!!!

I do not know why it worked in windows!!!

Thanks for your persistence!!!

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

> On 25 Aug 2004 at 11:59, blahclayton wrote:
>
> > if(text != NULL)
> > {
> > nullid = 0;
> > sqlda->sqlvar[i].sqldata = text;
>
> Don't forget set sqllen here too.
>
> > {
> > sqlda->sqlvar[i].sqllen = 0;
> > nullid = -1;
> > }
> > // sets up each parameter
> > sqlda->sqlvar[i].sqltype = SQL_TEXT;
>
> SQL_TEXT+1;
>
> This '1' indicates that parameter is nullable and sqlind is used.
>
> SY, Dimitry Sibiryakov.