Re: Syntax to pass IN parameters through ODBC

Sheeraz fazal wrote:

> I am accessing PostgreSQL 7.3.2 through psqlodbc. I need to call a my
> function "get_number(integer)". I don't know which place holder should i
> use that ODBC do know that this is for "integer" parameter.
>
> I am using VisualC++. Which require that, parameters should be bound to
> some name (column name or parameter name) before calling the db function.
>  ...
> But when i introduct an IN parameter like
> "?=call get_number(?)" it doesn't work.

You are indeed using the correct syntax.
(?) is the placeholder for any type of parameter.
Check the doc for SQLBindParameter().
You should be binding to parameters 1 and 2.