Re: Syntax to pass IN parameters through ODBC - Mailing list pgsql-odbc

From Mischa Sandberg
Subject Re: Syntax to pass IN parameters through ODBC
Date
Msg-id lOVVc.43889$X12.26691@edtnps84
Whole thread Raw
In response to Syntax to pass IN parameters through ODBC  ("Sheeraz fazal" <ng@iwerx.vertextek.com>)
List pgsql-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.

pgsql-odbc by date:

Previous
From: Mischa Sandberg
Date:
Subject: Re: ODBC questions
Next
From: Mischa Sandberg
Date:
Subject: Re: [iODBC] Driver could not be loaded, SQLSTATE=IM002