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
Views: Raw Message | Whole Thread | Download mbox
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

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2006-04-26 12:58:14 Re: odbc 8.01.02 8190 bytes limitation
Previous Message Michael GUIARD 2006-04-26 07:52:51 Re: odbc 8.01.02 8190 bytes limitation