°ïÎÒ¿´¿´delphi²Ù×÷Êý¾Ý¿â
strsqlc := 'select tradeId,state,payTime,tradeId1,paystate1 from payfee, temp'+
'where temp.tradeId1 = payfee.tradeId and payfee.state <> temp.paystate1'+
'and cdate(payTime) between cdate(:beginTime) and cdate(:endTime)';
ÕâÀïÄÄÀïÓÐÎÊÌâ
ºóÃæµÄÄǸöÒýºÅÄÇÒ²ÊÇÓÐÕâ¸öÎÊÌâ
strsqlc := 'select tradeId,state,payTime,tradeId1,paystate1 from payfee, temp'+
'where temp.tradeId1 = payfee.tradeId and payfee.state <> temp.paystate1'+
'and cdate(payTime) between cdate(:beginTime) and cdate(:endTime)';
Á½ÐÐÖ®¼ä¶¼È±¿Õ¸ñ
лл£¡Õâôһ¸öСϸ½Ú¸ãÁËÎÒ°ë¸ö¶àСʱ£¡
ѧϰÖС£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
¾ÍÊÇÒ»¸ö·þÎñ¶ËºÍÒ»¸ö¿Í»§¶Ë£¬Àï±ßÓÐһЩ¹²Óõ¥Ôª £¬ÎÒÔÚ ¹¤³ÌµÄSEARCH PATHÀïÉèÖõÄ·¾¶£¬
Àï±ßÓиö½á¹¹Ì壬ÎÒÔÚ·þÎñ¶Ë´ò¿ª£¬¼ÓÁ˳ÉÔ±£¬µ«ÊÇÎÒÔÚ¿Í»§¶ËÆäËûµ¥Ôª·ÃÎʲ»µ½ÎÒмӵģ¬ÎÒÔÚ¿Í»§¶Ë´ò¿ªÄǸöµ¥Ôª£¬È·Êµ¼ÓÁ ......
½ÓÊÕµ½µÄÎı¾ÄÚÈÝÊÇucs2±àÂë¸ñʽ£¬ÇëÎÊÔõÑùת»»³ÉÖÐÎÄ
°´ÎÒµÄÀí½â£¬UCS-2ÊÇ×Ö·û¼¯£¬¾ßÌåµÄ±àÂëÓÐUTF-8£¬UTF-16 (LE/BE)µÈ¡£
Èç¹ûÄãÓÃDelphi 2009¼°ÒÔÉϰ汾£¬¿ÉÒÔ¿´¿´TEncodingÀà¡£
btw. Äã˵µÄת»»³ÉÖÐÎÄÊÇɶÒâË ......
СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......
°´²»Í¬µÄÈË£¬²»Í¬µÄȨÏ޷ֱ𿪡£
·½·¨Ì«¶àÁË¡¡ÔÚÓû§µÄÐÅÏ¢Öжà¸ö²Ëµ¥ÁÐ±í¡£»òÕß°´È¨ÏÞ±ê¼ÇÔڲ˵¥µÄtagÀïÃæ£¬È»ºóÓû§È¨ÏÞÓëÕâ¸öȨÏÞ×ö¶Ô±È¡£Ì«¶àÁË¡¡
Ò»°ã¿ØÖÆaction
ÓýÇÉ«¿ØÖÆ
ÎÒÏÖÔÚÕýºÃÔÚ×öÕⷽà ......