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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly