Re: CADORecordBinding ... adDate

Erland, that was the trick. Since the value in the bind is already a double
I do not need all of the extra code associated with _variant_t. There is a
clean conversion with VariantToSystemTime (sp).

THANKS!!!!!

> beginthreadex (beginthreadex@xxxxxxxxxxx) writes:
>> I am using RecordBinding from VC++ successfully against a SQL server
>> 2000 database. My issues revolve around getting datetimes from SQL into
>> anything readable in VC++ as a date/double/ULARGE??? variable. Right now
>> I can put this data into a double but the data is not able to be parsed.
>> There does not seem to be a clean conversion from double to a FILETIME
>> or other struct.
>>
>> How can I use CADORecordBinding and get a "getdate()" value from SQL
>> without converting to a varchar(x)?
>>
>> The sample in MSDN states using a DBDATE variable, but there's no success
>> with this. It also states that you should use ADO_FIXED in one sample and
>> then another is ADO_VARIABLE ... so I'm really confused and would really
>> welcome a solution at this point.
>
> The type indicator to use in OLE DB is DBTYPE_DBTIMESTAMP. Really how
> that translates when you drag in ADO, I don't know, as I have not
> worked with ADO from C++.
>
>

--
new
.