Click here to Skip to main content
15,906,467 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Class wizard problem Pin
Obliterator5-Feb-03 9:51
Obliterator5-Feb-03 9:51 
GeneralRe: Class wizard problem Pin
stv6-Feb-03 4:15
stv6-Feb-03 4:15 
Generalfloat Root(float x, float y) Pin
The_Server2-Feb-03 17:02
The_Server2-Feb-03 17:02 
GeneralRe: float Root(float x, float y) Pin
Colin Urquhart2-Feb-03 17:17
Colin Urquhart2-Feb-03 17:17 
GeneralRe: float Root(float x, float y) Pin
The_Server2-Feb-03 17:41
The_Server2-Feb-03 17:41 
GeneralRe: float Root(float x, float y) Pin
The_Server2-Feb-03 18:12
The_Server2-Feb-03 18:12 
GeneralRe: float Root(float x, float y) Pin
The_Server2-Feb-03 18:40
The_Server2-Feb-03 18:40 
GeneralCRecordset and SQL problem Pin
Stefan Dahlin2-Feb-03 14:44
Stefan Dahlin2-Feb-03 14:44 
Hi
I have a SQL question that looks something like this:

"SELECT DISTINCTROW Table1.strDate AS strDateEx, Sum(Table1.dfValue) AS dfValueEx
FROM Table1
GROUP BY Table1.strDate;"

What i want to do is that i have a table with dates. And i want one row for each day
with the sum for that day in the dfValueEx column. I have no problem on getting the
question to work when i try it in Access.

My problem is that i don't know how i could make this work in a CRecordset. When i try
i get a "Invalid character value for cast specification on column number 1 (strDate)" error.

What does this error mean, and how can i get this to work?
GeneralRe: CRecordset and SQL problem Pin
Stefan Dahlin2-Feb-03 14:57
Stefan Dahlin2-Feb-03 14:57 
GeneralXP Compatibility Mode Pin
Dov Sherman2-Feb-03 12:58
Dov Sherman2-Feb-03 12:58 
GeneralRe: XP Compatibility Mode Pin
Michael Dunn2-Feb-03 13:18
sitebuilderMichael Dunn2-Feb-03 13:18 
GeneralRe: XP Compatibility Mode Pin
Neville Franks2-Feb-03 13:46
Neville Franks2-Feb-03 13:46 
GeneralRe: XP Compatibility Mode Pin
Dov Sherman2-Feb-03 18:23
Dov Sherman2-Feb-03 18:23 
GeneralRe: XP Compatibility Mode Pin
Neville Franks2-Feb-03 18:52
Neville Franks2-Feb-03 18:52 
GeneralRe: XP Compatibility Mode Pin
Mike Nordell2-Feb-03 23:11
Mike Nordell2-Feb-03 23:11 
GeneralRe: XP Compatibility Mode Pin
Dov Sherman3-Feb-03 8:20
Dov Sherman3-Feb-03 8:20 
GeneralDockable Menu Bar Pin
Steven M Hunt2-Feb-03 11:48
Steven M Hunt2-Feb-03 11:48 
GeneralRe: Dockable Menu Bar Pin
Ben Burnett2-Feb-03 14:38
Ben Burnett2-Feb-03 14:38 
QuestionHow to get DLL dependencies info? Pin
almc2-Feb-03 11:17
almc2-Feb-03 11:17 
AnswerRe: How to get DLL dependencies info? Pin
Jesus Oliva2-Feb-03 13:16
Jesus Oliva2-Feb-03 13:16 
AnswerRe: How to get DLL dependencies info? Pin
Neville Franks2-Feb-03 14:19
Neville Franks2-Feb-03 14:19 
GeneralDOS file functions Pin
Steven M Hunt2-Feb-03 10:25
Steven M Hunt2-Feb-03 10:25 
GeneralRe: DOS file functions Pin
Anonymous2-Feb-03 10:43
Anonymous2-Feb-03 10:43 
GeneralRe: DOS file functions Pin
Steven M Hunt2-Feb-03 11:22
Steven M Hunt2-Feb-03 11:22 
GeneralRe: DOS file functions Pin
Chris Losinger2-Feb-03 13:27
professionalChris Losinger2-Feb-03 13:27 

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.