"beginthreadex" wrote:

>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.

>>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.
>
> I'm not familiar with RecordBinding, but ADO uses VARIANT's for the Value
> property in a Recordset.Fields.Item(blah).Value expression. And, if
> you're
> using ADO via the #import directive, it's a _variant_t. I typically use
> something like:
>
> void get_date(_variant_t& v, SYSTEMTIME& st)
> {
> memset(&st, 0, sizeof(st));
> _variant_t d(v);
> d.ChangeType(VT_DATE);
> VARIANT vr = d.Detach();
> VariantTimeToSystemTime(vr.date, &st);
> VariantClear(&vr);
> }
>
> Of course, error checking, good variable names, etc have been left out to
> make my posting easier :)
>
> If you don't use the _variant_t compiler helper type, note that the
> important function is VariantTimeToSystemTime: this is a standard
> automation function supplied by oleaut32.