Re: Parameters.Refresh error. - Mailing list pgsql-odbc

From Adam Biser
Subject Re: Parameters.Refresh error.
Date
Msg-id 43BF481C.3070608@gmail.com
Whole thread Raw
In response to Re: Parameters.Refresh error.  ("Campbell, Greg" <greg.campbell@us.michelin.com>)
Responses Re: Parameters.Refresh error.  ("Campbell, Greg" <greg.campbell@us.michelin.com>)
List pgsql-odbc
Campbell, Greg wrote:

> Is there a parameterized statement, without a stored procedure/user
> defined function, that can just act against a table, like "INSERT INTO
> mytable (fld1, file2) VALUES (?, ?)"

Yes, there is, and this is what I'm trying to use.  You set the
.CommandType to adCmdText, I believe (I don't have the code on this
machine).  When using .Refresh (yes, I know it's probably a bit slower
than adding them manually), the parameters would be added
"behind-the-scenes" according to the table(s) against which you are
running the command.

It sounds like the whole parameters part, whether by stored procs or SQL
are not yet implemented.

pgsql-odbc by date:

Previous
From: "Campbell, Greg"
Date:
Subject: Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? whichdll??
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000507 ] MSSQL syntax