| From: | "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | ODBC int2 Paremeters to PostgreSQL functions |
| Date: | 2004-03-12 08:04:04 |
| Message-ID: | 40516EF4.2445.73F5669B@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
I have a problem with passing parameters to a PostgreSQL function
using the ODBC driver.
I have delcared a PostgreSQL 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.
PostgreSQL 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-03-12 08:55:05 | Re: MS Access error "could not connect to remote socket" |
| Previous Message | chor kim seng | 2004-03-12 07:08:23 | MS Access error "could not connect to remote socket" |