Thanks Tom,
I did actually put the parameter binding examples in my original post,
but as they are in .NET speak it may not have been obvious.
I guess I should try to get this on the "things to do with the ODBC"
driver list. I should be able to look at the code myself, but I will have to
remember how to speak C.
Thanks again,
Gary.
On 14 Mar 2004 at 13:24, Tom Lane wrote:
> "Gary Doades" <gpd@gpdnet.co.uk> writes:
> > AFAICS it is only int2 types that are not typecast. All other
> > datatypes (except string and int4 which don't need it) are typecast
> > explicitly by the driver before being passed to the server.
>
> I see. AFAIR you hadn't mentioned that you were declaring the parameter
> as smallint to ODBC. I tend to agree that a cast should be added in
> that case. It's not my code though ...
>
> regards, tom lane