DelphiÖеÄʱ¼ä²éѯ£¡ÄܸæËßÎÒÄÄÀï´íÁËÂ𣿣¡
t5:=' 1=1 ';
if CheckBox5.Checked then
t5:=' ÉúÈÕ>=#'+DateToStr(DateTimePicker1.Date)+'# and ÉúÈÕ<=#'+DateToStr(DateTimePicker2.Date)+'#';
¹ØÓÚʼþµÄ¸ñʽºÍ½ç¶¨·û£¬access,sqlserver,oracle¶¼Óе㲻ͬ£¬ÄãÕâÑùÓ²±àÂ뽨Òé¿´¿´ÄãµÄÊý¾Ý¿âµÄ¸ñʽҪÇó¡£
½¨ÒéÄãÓòÎÊý¾Í¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣬ʱ¼äÓòÎÊý±êʶ£¬ÔÚ´ò¿ªÊý¾Ý¼¯µÄ֮ǰÓÃParaByName('ʱ¼ä²ÎÊý1').Value:=TDateTime±äÁ¿¼´¿É£¬ÕâÑù¿ÉÒÔ±ÜÃⲻͬµÄÊý¾Ý¿âµÄʱ¼ä±íʾ·¨ºÍ½ç¶¨·û²»Í¬µÄÎÊÌâ
Èç¹ûÊÇoracleµÄ»°£¬¿ÉÒÔÓÃto_dateº¯Êý·½±ãÃ÷È·µÄת»»,´ïµ½ÔÚsqlÓï¾äÖÐÓ²±àÂë
ÀýÈç:select * from ±í1 where ʱ¼ä×Ö¶Î1 >= to_date('19900101','yyyyMMdd')
Ó¦¸ÃÊÇÒýºÅÎÊÌâ
strµÄ»°Ó¦¸ÃÓÃ''' °É
ͬÒâ˼һ¥µÄ˵·¨¡£
Êý¾Ý¿â²»Í¬SQLÓï¾äÂÔÓв»Í¬¡£
Â¥Ö÷µ½µ×³öʲô´í
if CheckBox5.Checked then
t5:=' ÉúÈÕ>=#'+formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+'# and ÉúÈÕ<=#'+formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+'#';
Â¥Ö÷Èç¹ûÓõÄÊÇaccessÊý¾Ý¿âÄÇô
t5:=' ÉúÈÕ>=#'+formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+'# and ÉúÈÕ<=#'+formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+'#';
Èç¹ûÊÇmssqlÄÇô
t5:=' ÉúÈÕ>='''+formatdatetime('yyyy-mm-dd',DateTimePicker1.Date)+''' and ÉúÈÕ<='''+formatdatetime('yyyy-mm-dd',DateTimePicker2.Date)+'''';
½¨ÒéÓòÎÊý´«µÝÈÕÆÚ
ÎÒÓõÄÊÇsql server2000Êý¾Ý¿â¡£
²¹³äһϣ¬ÎÒÓõÄÊÇsql server2000µÄÊý¾Ý¿â£¬ÉúÈÕÀàÐÍÓõÄÊÇdatetim
Ïà¹ØÎÊ´ð£º
hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ³£ÉÏÀ´×ª×ªµÄ
ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔÒò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......
¾ßÌåÒªÇóÓ뱨³êQQ729851670
771234717
¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼
ÒýÓÃ
¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼
1.¸øÒ»¸ö×Ö¿ÉÒÔÏÔʾƴÒô£¬¶àÒô×ֵĻ°ÄÜÏÔʾ¶ÔÓ¦µÄ¶à¸öÆ´Òô
2.¶Ô°üº¬¶àÒô×ֵĴÊÓïÖÇÄÜʶ±ð¸ø³öÆ´Òô¡£
3.¶ÔÒ»¶Î ......
var
FXmlDoc:IXMLDomDocument;
begin
ʹÓÃFXmlDoc.save('Îļþ·¾¶')£»
½á¹û·¢ÏÖ±£´æºóµÄ¸ÃÎļþÖÐÎÄÈ«²¿ÎªÂÒÂ룬ÈçºÎ½â¾ö
end£»
²Î¿¼Õâ¸ö
http://blog.csdn.net/jiangnanandi/archive/2008/11/28/3399804.aspx ......
C/C++ code:
void RefreshThreadList (DWORD dwOwnerPID)
{
HANDLE hThreadSnap = NULL;
BOOL bRet = FALSE;
THREADENTRY32 te32 = {0};
int px=0;
......