Syntax to pass IN parameters through ODBC

Поиск
Список
Период
Сортировка
От Sheeraz fazal
Тема Syntax to pass IN parameters through ODBC
Дата
Msg-id 001801c41e7b$3fd10490$d903a8c0@glowtek.com
обсуждение исходный текст
Ответы Re: Syntax to pass IN parameters through ODBC  (Mischa Sandberg <mischa.sandberg@telus.net>)
Список pgsql-odbc
Hi,
 
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.
 
If i am calling a function which is not accepting any parameter but returning a value i am using the syntax
"?=call get_number()" and it works. But when i introduct an IN parameter like
"?=call get_number(?)" it doesn't work. I am not sure the format i am using is specific to VisualC++ or it is ODBC standard syntax.
 
Any response in this regard is highly appreciated.
 
Thanks,
 
 

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Michael Fork"
Дата:
Сообщение: Re: Access - ODBC - serial problem...
Следующее
От: "Philippe Lang"
Дата:
Сообщение: Re: @@IDENTITY (Was: Access - ODBC - serial problem)