From: | "Campbell, Greg" <greg(dot)campbell(at)us(dot)michelin(dot)com> |
---|---|
To: | Adam Biser <adambiser(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Parameters.Refresh error. |
Date: | 2006-01-08 16:35:14 |
Message-ID: | 43C13F42.9090102@us.michelin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Yes there is from the VB, data accees techniques side,..
or yes from the I or somebody I know has done this with pgodbc side?
Adam Biser wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
Attachment | Content-Type | Size |
---|---|---|
greg.campbell.vcf | text/x-vcard | 241 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-01-08 17:24:22 | Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? |
Previous Message | Campbell, Greg | 2006-01-08 16:32:17 | Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? |