|
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¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
920140
µù¥U®É¶¡: 2005-04-29 ¤å³¹: 4
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤@¤ë 03, 2006 8:34 am ¤å³¹¥DÃD: ½Ð±Ð¦U¦ì¥ý¶i,¦p¦ó¸Ñ¨M³Ð«Ø¸ê®Æ¶°(±q»·ºÝSQL 7.0¤U¸ü¸ê®Æ)ªº°ÝÃD??? |
|
|
¤p§Ì¥»¦aºÝ¨Ï¥ÎVISUAL FOXPRO 6.0,»·ºÝ¨Ï¥Î·L³nªºSQL 7.0 (NT SERVER 4.0)¤U¸ü¸ê®Æ©Ò²£¥ÍªºTABLE,¤å¦r³¡¤À³£·|¦h¤F¤@¨ÇªÅ¥Õªº¦ì¸m,¦p¥»¨Ó¤@Ӿǥͪº½s¸¹snoªº¸ê®Æ¬OS0001,¦@¬O¤¦ì¦r¤¸,¦ý¦]¬°·íªì³]©w®É¸ÓÄæ¦ì¬On¨Ï¥Î¤K¦ì¦r¤¸,¬G¨C¦¸Åã¥Ü¸ÓÄæ¦ì¸ê®Æ®É³£¬O"S0001 "¦@¤K¦ì,§Ú¨Ï¥Î¤FTRIM(SNO)¸òALLTRIM(SNO)³£µLªk§R°£,¦ý·í³oÓTABLE¬O¥»¦a¸ê®Æªí®É¨Ï¥Î³o¨âÓ«ü¥O³£¨S¦³°ÝÃD,¥u¦³±q»·ºÝ¤U¸ü¤U¨ÓªºTABLE¤~¦³°ÝÃD,½Ð±Ð¦U¦ì¤j¤jn¦p¦ó¸Ñ¨M!
PS:
¥»¦aTABLEªº±¡ªp,TRIM(ROAD)-TRIM(ADDRESS)=°ª¶¯¥«¤»¦X©]¥«
»·ºÝTABLEªº±¡ªp,TRIM(ROAD)-TRIM(ADDRESS)=°ª¶¯¥« ¤»¦X©]¥« |
|
¦^³»ºÝ |
|
|
abcyei
µù¥U®É¶¡: 2004-01-01 ¤å³¹: 48
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤@¤ë 09, 2006 11:49 pm ¤å³¹¥DÃD: |
|
|
¥ÎALLTRIM()¸Õ¸Õ |
|
¦^³»ºÝ |
|
|
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤@¤ë 10, 2006 9:08 am ¤å³¹¥DÃD: |
|
|
"µw"¬On³B²z°_¨Óªº¸Ü
«ØÓ¥»¦atable·íµM¤j¤p³]¤@¼Ë(¥Î¥¦¨Ó¥N´À¨ºÓ»·ºÝview¤£´N¦æ¤F)
¦A»¡¤F,sql ªº¨ç¼Æ¦n¹³©Mvfp ¤£¤Ó¤@¼Ë
select into array ªº¸Ü
append from array
¦³©R¦Wªº¸Ü,append ¶i¥h´N¦æ¤F
¦A»¡¤F¦³¨º¼Ëªº±¡ªp,Ãø§K·|¦³
##¤»¦X©]¥«
xxx¤»¦X©]¥«xxx(¨Ï¥ÎªÌ¿é¤Jªº¿ù»~)
·d¤£¦nÁÙ¦³
¤»¦X©]¥«¥ª
¤»¦X©]¥«¥kÃä.....
¤»¦X©]¥«¤U
¦pªG³o¼Ë,·íµM´N§Æ±æì¥ý¸ê®Æ¿é¤J®É,´N§âªø«×±±¨î¦n
¦b¿é¤Jªí³æ®É´N°µ³B²z¤F
¨º³oÓ°ÝÃD,¥i¯à´N¤£¦¨¥ß¤F |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤@¤ë 10, 2006 9:58 am ¤å³¹¥DÃD: |
|
|
¯u©Ç,
§Ú¤£ºÞ¬O¥Îdbf ©Î¬O sql cursor,
§ÀºÝªºªÅ¥Õ³£¬O®ø¤£±¼ªº,
©Ò¥H§Ú¦b³B²z¦r¦ê¤ñ¸û®É,
Y»Ýn²M°£§ÀºÝªºªÅ¥Õ,³£·|¦b³B²z®É¤~¥[¤Walltrim()©Î¬Ortrim() _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤@¤ë 10, 2006 2:27 pm ¤å³¹¥DÃD: |
|
|
§Ú·Q°_¤@¥ó¨Æ±¡¤F
¤§«e
Ó¤H´¿¼g
¥Î¦a§}ªº«e´XÓ¦r¤¸¿ë§O¹B°e¦aÂI
¦n¹³¥u¨ì¿¤¦Ó¤w
¸ê®Æ®wùس]¤F10´XÓ¿¤¥«,¹B¶O,¤Î¹B¶O¦¨¥»
¦Ó¿é¤J¤Hû¤£Ä@¥Î¥N½X
©Ò¥H¼g¦¨¤F±q¦a§}¤¤ºI¨ú´X½X¤¤¤å,¦^¥h¹ï¨ì¥N½X
¦A¼g¤J¥X³f¸ê®Æ®w,¯u¬OÁ}¨¯ªº¤@¥ó¨Æ
ÂÇ¥Hpºâ¥X«È¤á©Ò»Ý¹B¶O,¤Î©Ò¤ä¥I¥q¾÷ªº¹B¶O¦¨¥»
³oÓ¨Ò¤lˬOÅý§Ú·Q¨ì¨º¨Æ
¦pªG¹³¬O¤»¦X©]¥«ªº¨Ò¤l
´N§ì¨ì¤»¦X©]¥«¹ï¦^¸ê®Æ®wªº¥N½X
½ÖºÞ¥ªÃä,¥kÃä,¤W±ÁÙ¬O¤U±,
ª½¨ì¬Y®a§@¨Æ®É,«x...´N¬Ý¨ì¤F¦a§}²° |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|