|
Hi,
I have query regarding Dates/Time field in MS Access.In MS Access Database I am using one of the field is Date/Time.I am using "General Date" .(i.e)6/27/01 6:59:00 .I am using SQL Query to get all the Records within two date ranges.The query looks like this
SELECT * FROM <tablename> WHERE <datefield> BETWEEN <date1> And <date2>
I am getting all the records inclusive of lower bound but exclusive of the upper bound date.
What may be the problem.Have I to modify the query ?
Regards,
yamini.
|
|
|
|
|
between ? and ?
how do you declare the range?,it's very important.
|
|
|
|
|
I am giving the sql I used,
TableName is "LogTable"
DateField is "StationTime"
SELECT * FROM LogTable WHERE StationTime BETWEEN #6/25/2001# And #6/27/2001# .
In the DataBase I am having Records with Dates ranging from 6/25/2001 to 6/27/2001.I am getting Records with date 6/25/2001 .But could not get the Records with date 6/27/2001.
Hope I am clear.
Thanx for the Response.
Regards,
yamini
|
|
|
|
|
You can try #6/27/2001 23:59:59#.
I think the default value of time is 6/27/2001 0 .
|
|
|
|
|
Yes.Thanx for the idea.I included the time along with date.Now it works perfectly.I am getting all the required records with the lower and upper date bound.The problem is solved.
Regards,
yamini
|
|
|
|
|
I have made a cursor with cursor editor and the device is 32*32,256 colors. but it can't use. why?
thanks.
|
|
|
|
|
What is the easiest way to convert a HBITMAP to JPEG file in C/C++?
Thanks,
Regards,
Xavier
|
|
|
|
|
I don't know why that didn't post - I'll try again. Use GDI+, read the Doodle article on this site.
Jonathon
|
|
|
|
|
Hi everyone! This is my first foray into 'The Code Project'.
I learned windows programming through MFC and I'm just now going back and trying to relearn it without MFC (so that presumably when I return to using it I will have a much higher appreciation.) Anyway, I have a simple problem and I would be grateful for help with it.
I made the default MSVC 6.0 SDK 'Hello World' project. Then I put some controls on it using CreateWindow("EDIT"...) and "STATIC" and "BUTTON". Now I want a window that simply sends a message to the parent giving client x,y coordinates when it is clicked on. The way I used to do this was just to capture the clicks in the main window and do the calculations to see whether the click was in any of the child windows. I tried subclassing (I just learned what subclassing is) a "STATIC" window to handle the WM_LBUTTONDOWN, but it acts like it's not even there . I know the subclassing worked though because it handles WM_PAINT fine.
Thank you!
|
|
|
|
|
When you create the static control add the SS_NOTIFY style. This will make the control send the STN_CLICKED notification message when the window gets clicked on.
-Ben
---------
On the topic of code with no error handling -- It's not poor coding, it's "optimistic" 
|
|
|
|
|
I saw that option while I was poking around (though it doesn't help that SS_NOTIFY isn't in the MSDN help index  ) and I dismissed it after looking at the scant offerings of STN_* (I think they were 'click' 'dblclick' 'enable' and 'disable' or something) since I needed more information (like *where* they clicked and which button) which is why I decided to learn about subclassing.
Anyway, I tried the SS_NOTIFY style just for the hell of it, and lo and behold all of the subclassing stuff I was trying to do started working! I guess the subclassing doesn't work unless you have SS_NOTIFY on, though I can't find that in the help anywhere.
Thank you, Benner! 
|
|
|
|
|
Is there any other build-in function that can receive the window message or message generated by driver?
I just know that WindowProc() is one of the function.....
Thanks
|
|
|
|
|
using the windows hook.
SetWindowHookEx(...),you can find more detail from Msdn.
|
|
|
|
|
I an trying to pass a CArray object as a parameter to a function.
code is somewhat like this:
"
void SetPoints(CArray"<"CPoint, CPoint&">" points);
anotherfunction{
CArray"<"CPoint, CPoint&">" myArray;
SetPoints(myArray);
....
}
I keep getting compilation errors saying that it cannot convert parameter 1 of SetArray from
CArray<cpoint, cpoint&=""> to CArray<cpoint, cpoint&="">
"
does not make sense to me!!
Please respond by e-mail if you know what's ahappend..
really need it badly!!
|
|
|
|
|
void SetPoints(CMyArrayType &array)
{
...
}
you need to pass the array as a reference
------------------------------
Smaller Animals Software, Inc.
http://www.smalleranimals.com
|
|
|
|
|
#include '<'afxtempl.h'>'
Cheers!!!!
Carlos Antollini.
|
|
|
|
|
#include '<'afxtempl.h'>'
Cheers!!!!
Carlos Antollini.
Carlos Antollini.
|
|
|
|
|
I an trying to pass a CArray object as a parameter to a function.
code is somewhat like this:
"
void SetPoints(CArray<cpoint, cpoint&=""> points);
anotherfunction{
CArray<cpoint, cpoint&=""> myArray;
SetPoints(myArray);
....
}
I keep getting compilation errors saying that it cannot convert parameter 1 of SetArray from
CArray<cpoint, cpoint&=""> to CArray<cpoint, cpoint&="">
"
does not make sense to me!!
Please respond by e-mail if you know what's ahappend..
really need it badly!!
|
|
|
|
|
I an trying to pass a CArray object as a parameter to a function.
code is somewhat like this:
void SetPoints(CArray<cpoint, cpoint&=""> points);
anotherfunction{
CArray<cpoint, cpoint&=""> myArray;
SetPoints(myArray);
....
}
I keep getting compilation errors saying that it cannot convert parameter 1 of SetArray from
CArray<cpoint, cpoint&=""> to CArray<cpoint, cpoint&="">
does not make sense to me!!
Please respond by e-mail if you know what's ahappend..
really need it badly!!
|
|
|
|
|
You're trying to pass CArray by value. This fails, because CArray has no copy constructor defined. To solve the problem, pass array by reference:
void SetPoints(CArray<CPoint, CPoint&> & points);
Tomasz Sowinski -- http://www.shooltz.com.pl
|
|
|
|
|
I don't know if it will help you, but...
I have never passed a CArray object to a function, but I have returned one from it.
//prototype.
CArray <strctpaquetreldocreceptor,strctpaquetreldocreceptor&> *GetArrayPaquetRelDocReceptors();
//return of the CArray (inside the f(x))
CArray <ctamcontrolcenterapp::strctpaquetreldocreceptor,ctamcontrolcenterapp::strctpaquetreldocreceptor&> *CTAMControlCenterApp::GetArrayPaquetRelDocReceptors()
{
return &m_ArrayPaquetRelDocReceptor;
}
I remember that without the #include <afxtempl.h> inside the stdafx.h it didn't work...
This is the same but in the reverse order, I expect it helps you...
I'm a novice speaking english, I'm sure you will have noticed it... I beg your pardon...
|
|
|
|
|
Hi all,
I have trouble refreshing one static text after having set it to WM_VISIBLE off
if I minimize & maximise again the static is gone but how can I send order to refresh
the static text directly.
I tried already invalidatrect drawwindows() and some other solutions, nothing work.
I suppose that I should invalidat the Cstatic object (in fact the excellent CLabel class
derived from CStatic) then send a WM_PAINT to the main but I don't know how to exactly
do this following the rules to get clean code. (I'm newbies at MFC)
Thanks for any help
Dany
|
|
|
|
|
Using WS_VISIBLE is similar to using the following function:
ShowWindow(hwnd, SW_HIDE); //This hides the window!
To re-show or make visible:
ShowWindow(hwnd, SW_SHOW);
Mh2! 
|
|
|
|
|
don't set id of the static control to id_static,
it must unique
|
|
|
|
|
Many thanks, just tried it work fine...
I dealed with several API and language and was always suspicious  about MFC but it's
incredible what we can do in no time 
I don't want to abuse but one more question:
Is there a ways to avoid immediate refresh when setting SW_SHOW cause I have several
static (another name of course  ) to show and even if it's fast we can see that
they come up one by one.
something like :
DisableWindowsUpdate();
..SW_SHOW
..SW_SHOW
...
EnableWindowsUpdate();
Again thanks it will be my last question (for this thread of course )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
