Click here to Skip to main content
15,898,134 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralFinding the corect view Pin
Poorniselva13-Jun-04 18:34
Poorniselva13-Jun-04 18:34 
GeneralRe: Finding the corect view Pin
Johan Rosengren13-Jun-04 20:49
Johan Rosengren13-Jun-04 20:49 
QuestionHow to list all the files in a folder, CFileFinder not work Pin
pingpongpp13-Jun-04 16:47
pingpongpp13-Jun-04 16:47 
AnswerRe: How to list all the files in a folder, CFileFinder not work Pin
Anthony_Yio13-Jun-04 23:15
Anthony_Yio13-Jun-04 23:15 
AnswerRe: How to list all the files in a folder, CFileFinder not work Pin
Johan Rosengren14-Jun-04 1:04
Johan Rosengren14-Jun-04 1:04 
AnswerRe: How to list all the files in a folder, CFileFinder not work Pin
David Crow14-Jun-04 3:31
David Crow14-Jun-04 3:31 
GeneralSQL Pin
Yulianto.13-Jun-04 16:28
Yulianto.13-Jun-04 16:28 
GeneralRe: SQL Pin
Anthony_Yio13-Jun-04 23:09
Anthony_Yio13-Jun-04 23:09 
I think the way you use LIKE is correct but the field type of your myDate might be causing the problem. Is it a VARCHAR or TEXT type? If it is a DATE type, probably this won't work. You need something like this

result.Format(" date '%4d-%02d-%02d' ",d.GetYear(),d.GetMonth(),d.GetDay());


and use = or >= instead.

So your SQL statement should be

SELECT * FROM PO WHERE PO.PURCHASED_DATE = date '1997-12-31'


The example SQL statement above is from PL-SQL of the Oracle but should be compatible on T-SQL and the rest.

Hope this helps

Sonork 100.41263:Anthony_Yio

GeneralDrawing in a CWnd derived custom control. Pin
kfaday13-Jun-04 16:21
kfaday13-Jun-04 16:21 
GeneralRe: Drawing in a CWnd derived custom control. Pin
Johan Rosengren13-Jun-04 20:46
Johan Rosengren13-Jun-04 20:46 
QuestionSet text of window in another thread? Pin
Ravi Bhavnani13-Jun-04 13:38
professionalRavi Bhavnani13-Jun-04 13:38 
AnswerThe answer Pin
Ravi Bhavnani13-Jun-04 14:05
professionalRavi Bhavnani13-Jun-04 14:05 
AnswerRe: Set text of window in another thread? Pin
David Crow14-Jun-04 3:36
David Crow14-Jun-04 3:36 
GeneralRe: Set text of window in another thread? Pin
Ravi Bhavnani14-Jun-04 6:11
professionalRavi Bhavnani14-Jun-04 6:11 
GeneralRebar: Dialog bar Pin
Jorgen E.13-Jun-04 13:06
Jorgen E.13-Jun-04 13:06 
GeneralRe: Rebar: Dialog bar Pin
palbano14-Jun-04 5:20
palbano14-Jun-04 5:20 
GeneralRe: Rebar: Dialog bar Pin
Jorgen E.14-Jun-04 10:08
Jorgen E.14-Jun-04 10:08 
Generaldiscussing: email servers Pin
includeh1013-Jun-04 10:08
includeh1013-Jun-04 10:08 
GeneralRe: discussing: email servers Pin
bneacetp13-Jun-04 10:15
bneacetp13-Jun-04 10:15 
GeneralRe: discussing: email servers Pin
includeh1013-Jun-04 10:33
includeh1013-Jun-04 10:33 
GeneralRe: discussing: email servers Pin
bneacetp13-Jun-04 10:40
bneacetp13-Jun-04 10:40 
GeneralRe: discussing: email servers Pin
toxcct13-Jun-04 10:48
toxcct13-Jun-04 10:48 
GeneralAudio input level Pin
tojegi13-Jun-04 9:56
tojegi13-Jun-04 9:56 
GeneralVoice recorder Pin
Michae_geffen13-Jun-04 8:27
Michae_geffen13-Jun-04 8:27 
QuestionRunning in Background? Pin
DanYELL13-Jun-04 7:28
DanYELL13-Jun-04 7:28 

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.