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

Re: PG 8 INOUT parameters & ADO

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: PG 8 INOUT parameters & ADO
Date: 2006-04-26 07:56:31
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Hi Hiroshi,

It works fine, thanks.

Now I can use:

oCommand.Parameters(0).Value = a
oCommand.Parameters(1).Value = b

Just one question, which might be ADO-specific... Is the refresh capable of
recognizing the parameters names?
After the refresh, all parameters names are set to "". If they inhereited
the names of the parameters in Postgreql, that would allow us to do
something like:

oCommand.Parameters("a").Value = a
oCommand.Parameters("b").Value = b 

That would avoid confusion and bugs when giving initial values to the

-----Message d'origine-----
De : Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp] 
Envoyé : mardi, 25. avril 2006 23:32
À : Philippe Lang
Cc : Ludek Finstrle; pgsql-odbc(at)postgresql(dot)org
Objet : Re: [ODBC] PG 8 INOUT parameters & ADO

Philippe Lang wrote:

>There is small problem apparently: if I replace

Please replace the dll by the one at .

Hiroshi Inoue

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2006-04-26 12:58:14
Subject: Re: odbc 8.01.02 8190 bytes limitation
Previous:From: Michael GUIARDDate: 2006-04-26 07:52:51
Subject: Re: odbc 8.01.02 8190 bytes limitation

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