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.