[Oledb-dev] Is it time for 1.0.0.20?

Shachar Shemesh psql at shemesh.biz
Tue Apr 18 10:15:36 UTC 2006


Victor Snezhko wrote:

>>Until now I didn't know too :)
>>Now I wonder why is SetParameterInfo needed at all...
>>    
>>
I think I got it.


Parameters for which "SetParameterInfo" was called have their DB side
type dictated for them. Parameters which were skipped (SetParameterInfo,
after all, is at liberty to not specify some types at all) we assume
that the type with which we were passed the info is the same type we
send it out.


I'm not even sure this makes any sense at all. We have some data type
conversion functions that we inherit for free from the ATL class, and
Execute already uses it to convert the passed data type to the correct
data type (our functions, after all, don't know how to handle a type of
"VARIANT", so it needs to be converted to something else, say DWORD or
WSTRING before we can convert it to something Postgresql will understand).


Now I'm wondering whether to have a per command types and per execution
types. The former are set using SetParameterInfo and the later by Execute?


          Shachar



More information about the Oledb-devel mailing list