Skip site navigation (1) Skip section navigation (2)

Re: DescribParam

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: "Glenn B(dot) Lawler" <gblawler(at)incodesystems(dot)com>
Cc: "'PostgreSQL ODBC List'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: DescribParam
Date: 2006-06-07 19:23:31
Message-ID: 20060607192331.GB28221@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> When I call SQLDescribeParam using PostgreSQL ODBC Driver
> psqlodbc-08_02_0002 SQL_ERROR is the return code.

This API has never been supported. Why do you use it when psqlODBC
returns info that it doesn't support SQLDescribeParam?

> What I am trying to do with this call is determine the buffer size
> needed to allocate a buffer so I can call SQLBindParameter with
> a big enough buffer.

There is the problem that PgSQL backend doesn't support it before
execution (I haven't found another information yet).

> My only thought was to provide an override for this in my library
> to force the parameter size when the driver does not return it.

Maybe you may depend on other information like PostgreSQL driver, ...

> Does anyone have a better workaround for this?

Sorry, I don't have one.

Regards,

Luf

In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-06-07 19:31:12
Subject: CVS and open cursor
Previous:From: Glenn B. LawlerDate: 2006-06-07 19:03:56
Subject: DescribParam

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group