Subject Re: [firebird-support] select statements using api
Author Dimitry Sibiryakov
On 19 Aug 2004 at 14:44, blahclayton wrote:

>I was hoping to get all paramater types as char* without having to
>convert them as shown in firebird example apifull.c. Is this possible?

Not for all types of fields. It is impossible for BLOBs.

>If so how do I set up the XSQLDA to pass to the isc_dsql_fetch?

The same way as input SQLDA. The easiest way: call isc_dsql_prepare
and then set sqlvar[i].sqltype = SQL_TEXT | (sqlvar[i].sqltype & 1);
The last piece is purposed to preserve "nullable" sign.

SY, Dimitry Sibiryakov.