Hi,

I have a doubt about the XSQLDA parameter in isc_dsql_prepare api.

If I have the following statement: SELECT field1 FROM table
I should prepare and pass an XSQLDA structure for receiving output

If I have: UPDATE table SET field1=?
I should prepare and pass an XSQLDA structure for parameter input

But if I have: SELECT field1 FROM table WHERE field2=?
What should I prepare?

a) Two different arrays (XSQLDA structures), one for the parameter and other for processing the output?

b) Only one array containing a "mix" of parameters/outputs

Best regards,
Mauro.