Re: Parameters.Refresh error.

oops,..goofy typing.
Is that
"Yes there is.., parameterization on a SELECT or DML statement is a valid VB/MS data access technique",..
or is  that
"Yes, I or someone I know has done this is pgodbc"?




Campbell, Greg wrote:
> 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
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly