ODBC int2 parameters to pg function
| От | Gary Doades |
|---|---|
| Тема | ODBC int2 parameters to pg function |
| Дата | |
| Msg-id | 08eu40du2j0hjmc1k36a3k5m73moqm34n9@4ax.com обсуждение исходный текст |
| Ответы |
Re: ODBC int2 parameters to pg function
|
| Список | pgsql-odbc |
I have discovered a problem with passing parameters to a pg function
using the ODBC driver.
I have delcared a pg function as:
function GENERATE_TIMESHEETS(timestamp,timestamp,smallint,smallint)
....
I have a .NET program that uses the following:
cmd.CommandText = "SELECT GENERATE_TIMESHEETS(?,?,?,?)";
cmd.Parameters.Add("DATE_FROM",OdbcType.DateTime,8);
cmd.Parameters.Add("DATE_TO",OdbcType.DateTime,8);
cmd.Parameters.Add("TIME_FROM",OdbcType.SmallInt,2);
cmd.Parameters.Add("TIME_TO",OdbcType.SmallInt,2);
I then assign the parameter values and execute the statement.
pg returns an error stating
GENERATE_TIMESHEETS(timestamp,timestamp,int4,int4) cannot be found
It appears that the ODBC driver is not typecasting the smallint (int2)
parameters correctly for the function call.
Can anyone shed any light on this?
Thanks
Gary.
В списке pgsql-odbc по дате отправления: