Thanks for the reply. I thought and actually used it in output SQLDA
where I did not set the sqllen for SQL_LONG and SQL_DOUBLE datatype
and works.

Did not realize thata I had to set sqllen for input SQLDA. Now I
don't have to execute the describe_bind call.

Thanks you, Dimitry.


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

>
> On 24 Apr 2006 at 17:48, Jeff Lynn wrote:
>
> >Can someone tell me why I need the isc_dsql_describe_bind to execute
> >the prepared stmt works?
>
> Because you don't fill SQLDA completely and properly, so you have
> to ask FB server to do so.
>
> >I created the table, with Id set to integer, since there is no
> >SQL_INTEGER or SQL_INT, I uses SQL_LONG. I even dumped the pSqlda
> >after the bibd, which is exactly what I entered.
>
> Including sqllen?
>
> >The API Doc stated that if I know the datatype of the parameeer, I
> >don't need to exeecute the bind. But that is not what I saw.
>
> In this case you must fill all relevant fields in XSQLVAR.
>
> --
> SY, Dimitry Sibiryakov.
>