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.