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: 6C0CF58A187DA5479245E0830AF84F421D0C1F@poweredge.attiksystem.ch (view raw or flat)
Thread:
Lists: pgsql-odbc
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

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-2014 The PostgreSQL Global Development Group