VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

¦P¤@­ÓTable¤¤¦hµ§Record select¦¨¤@µ§

 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
easttall



µù¥U®É¶¡: 2006-03-15
¤å³¹: 1


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤T¤ë 15, 2006 5:56 pm    ¤å³¹¥DÃD: ¦P¤@­ÓTable¤¤¦hµ§Record select¦¨¤@µ§ ¤Þ¨¥¦^ÂÐ

½Ð°Ý¤@¤U¦U¦ì¤j¤j,°²³]§Ú¦³¤@­ÓTable

Table A:

aaa bbb TIME_A
=============
xxx R 2006/12/13
xxx D 2006/12/14
yyy R 2006/12/15
yyy D 2006/12/16
uuu R 2006/12/17
uuu D 2006/12/18

§Ú«ç»ò¤USQL¤~¯à±o¨ì:

aaa R_TIME D_TIME
================
xxx 2006/12/13 2006/12/14
yyy 2006/12/15 2006/12/16
uuu 2006/12/17 2006/12/18
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
bin1x



µù¥U®É¶¡: 2004-08-27
¤å³¹: 462


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤T¤ë 15, 2006 8:05 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

sql ùئ³­Ó´Î²yªº¨Ò¤l
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó °ÑÆ[µoªí¤Hªº­Ó¤Hºô¯¸ MSN Messenger
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
²Ä1­¶(¦@1­¶)

 
«e©¹:  
±z µLªk ¦b³o­Óª©­±µoªí¤å³¹
±z µLªk ¦b³o­Óª©­±¦^ÂФ峹
±z µLªk ¦b³o­Óª©­±½s¿è¤å³¹
±z µLªk ¦b³o­Óª©­±§R°£¤å³¹
±z µLªk ¦b³o­Óª©­±¶i¦æ§ë²¼
±z µLªk ¦b³o­Óª©­±ªþ¥[ÀÉ®×
±z µLªk ¦b³o­Óª©­±¤U¸üÀÉ®×


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@