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: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: PG 8 INOUT parameters & ADO
Date: 2006-04-28 07:50:59
Message-ID: 6C0CF58A187DA5479245E0830AF84F421D0C35@poweredge.attiksystem.ch (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

Sorry to ask this question again, but is there a chance ADO
"oCommand.Parameters.Refresh" could get the parameters names configured in
Postgresql? The idea is to be able to do something like:

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

Instead of

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


Thanks, bye

Philippe


-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Philippe Lang
Envoyé : mercredi, 26. avril 2006 09:57
À : Hiroshi Inoue
Cc : pgsql-odbc(at)postgresql(dot)org
Objet : Re: [ODBC] PG 8 INOUT parameters & ADO

Hi Hiroshi,

It works fine, thanks.

Now I can use:

oCommand.Parameters.Refresh
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.Refresh
oCommand.Parameters("a").Value = a
oCommand.Parameters("b").Value = b 

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

-----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:

>Ludek,
>
>There is small problem apparently: if I replace
>  
>

Please replace the dll by the one at
 http://www.geocities.jp/inocchichichi/psqlodbc/index.html .

regards,
Hiroshi Inoue

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2006-04-28 08:22:35
Subject: [ psqlodbc-Bugs-1000604 ] 8.01.0200 slow with long queries
Previous:From: Jean HuveneersDate: 2006-04-27 19:09:00
Subject: Re: Error when I try to update

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