Click here to Skip to main content
15,921,250 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: exporting std::string Pin
cmk2-Sep-03 14:05
cmk2-Sep-03 14:05 
Generalunicode woes Pin
Jim Crafton2-Sep-03 7:08
Jim Crafton2-Sep-03 7:08 
GeneralRe: unicode woes Pin
cmk2-Sep-03 7:50
cmk2-Sep-03 7:50 
GeneralRe: unicode woes Pin
Jim Crafton2-Sep-03 8:07
Jim Crafton2-Sep-03 8:07 
GeneralRe: unicode woes Pin
cmk2-Sep-03 9:12
cmk2-Sep-03 9:12 
GeneralMultiple views and single document Pin
Binayak2-Sep-03 6:34
Binayak2-Sep-03 6:34 
GeneralRe: Multiple views and single document Pin
palbano2-Sep-03 7:25
palbano2-Sep-03 7:25 
GeneralVC++ / MSAccess Date Handling Pin
msdaug2-Sep-03 6:15
msdaug2-Sep-03 6:15 
I'm adding a record to an Access database via ADO and then trying to query for that record based on the date:

m_addTime = COleDateTime::GetCurrentTime();
...
VARIANT v;
VariantInit(&v);
V_VT(&v) = VT_DATE;
V_DATE(&v) = m_addTime;
pRS->Fields->Item[_variant_t((long)1)]->Value = v;

This works fine, but querying for the time value has me stumped:

CString sql;
sql.Format("SELECT id, dtTime FROM tblSample WHERE dtTime = %f", (double)m_addTime);
pRS = m_pDB->ExecuteRS_ReadOnly(sql);

...returns no rows.
dtTime is a Date/Time value in the access table.

D'Oh! | :doh: Any clues would be appreciated
GeneralRe: VC++ / MSAccess Date Handling Pin
palbano2-Sep-03 6:56
palbano2-Sep-03 6:56 
GeneralRe: VC++ / MSAccess Date Handling Pin
msdaug2-Sep-03 9:56
msdaug2-Sep-03 9:56 
GeneralRe: VC++ / MSAccess Date Handling Pin
msdaug2-Sep-03 14:10
msdaug2-Sep-03 14:10 
GeneralRe: VC++ / MSAccess Date Handling Pin
Steve S3-Sep-03 2:23
Steve S3-Sep-03 2:23 
GeneralRe: VC++ / MSAccess Date Handling Pin
msdaug10-Sep-03 8:00
msdaug10-Sep-03 8:00 
GeneralHelp! Figure out whats wrong! FOR LOOP-ing! Pin
colormyiris2-Sep-03 5:50
colormyiris2-Sep-03 5:50 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
Ted Ferenc2-Sep-03 6:54
Ted Ferenc2-Sep-03 6:54 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
David Crow2-Sep-03 7:39
David Crow2-Sep-03 7:39 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
Ted Ferenc2-Sep-03 7:48
Ted Ferenc2-Sep-03 7:48 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
Andrew Allen2-Sep-03 10:10
Andrew Allen2-Sep-03 10:10 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
David Crow2-Sep-03 7:45
David Crow2-Sep-03 7:45 
GeneralI need a MMC expert Pin
YaronNir2-Sep-03 4:57
YaronNir2-Sep-03 4:57 
GeneralPlease explain this error message for me. T__T Pin
2-Sep-03 4:49
suss2-Sep-03 4:49 
GeneralRe: Please explain this error message for me. T__T Pin
Ian Darling2-Sep-03 5:03
Ian Darling2-Sep-03 5:03 
QuestionHow add aplication in Internet Explorer Rebar Pin
Denis A. Vergara2-Sep-03 4:48
Denis A. Vergara2-Sep-03 4:48 
QuestionGetTextMetrics results depends of text angle ? Pin
JP GOBLET2-Sep-03 4:35
JP GOBLET2-Sep-03 4:35 
Generalmemory allocation in C Pin
ravingcoder2-Sep-03 4:31
ravingcoder2-Sep-03 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.