µoªí¤H |
¤º®e |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤G¤ë 26, 2021 11:24 am ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
close databases
create cursor ta (¾Ç¸¹ c(5), ½Ò¦W c(100))
insert into ta (¾Ç¸¹) select distinct ¾Ç¸¹ from tb
index on ¾Ç¸¹ tag xh
select tb
set relation to ¾Ç¸¹ ... |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤G¤ë 26, 2021 11:23 am ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
¦pªGn¥Îsql »yªk,¥i¯àn¤À¦¸°õ¦æsql
1. ¥ý§ä¥X½Ò¦W
select ½Ò¦W from table b group by ½Ò¦W into cursor tmp
2 select tmp
scan
select ¾Ç¸¹ from b where ½Ò¦W=tmp.½Ò¦W into cu ... |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤G¤ë 26, 2021 11:21 am ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
µo´§vfp cursor ªºªø³B
SELE TABLE_A
scan
repl A.DUMY_NAME WITH .....
ENDSCAN
·PÁ¦^ÂÐ
³o¤]¬O§Ú¥Ø«eªº°µªk.... ¦ýµ§¼Æ¤@¦hªº¸Ü¡Anªá¤ñ¸û¦h®É¶¡¡A©Ò¥H¤~·|·Q´M¨D¨ä¥L¤èªk
table b ¦³¤Uindex
´X ... |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤G¤ë 26, 2021 11:20 am ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Âà¨ì excel ±Æ¤@±Æ«á§ì¦^¨Ó
¤]¬O¤@Ó¤èªk
·PÁ¦^ÂÐ |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤G¤ë 25, 2021 2:53 pm ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
select DISTINCT name,
datelist=
(
SELECT cast(rundate AS NVARCHAR ) + ','
from #UEFO_Country
where name=t0.name --§âname¤@¼Ëªº¥[°_¨Ó
FOR XML PATH('')
) ... |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤G¤ë 25, 2021 2:37 pm ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
µo´§vfp cursor ªºªø³B
SELE TABLE_A
scan
repl A.DUMY_NAME WITH .....
ENDSCAN
·PÁ¦^ÂÐ
³o¤]¬O§Ú¥Ø«eªº°µªk.... ¦ýµ§¼Æ¤@¦hªº¸Ü¡Anªá¤ñ¸û¦h®É¶¡¡A©Ò¥H¤~·|·Q´M¨D¨ä¥L¤èªk |
¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
Bruce Lin
¦^ÂÐ: 12
Æ[¬Ý: 15734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤G¤ë 25, 2021 12:01 pm ¥DÃD: ½Ð°ÝVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD |
½Ð°Ý¦U¦ìVFP¥ý¶i¡AÃö©óVFP SQLÄæ¦ì¦X¨Ö¦r¦ê¬Û¥[ªº°ÝÃD
table A¡@¡@table b
¾Ç¸¹¡@¡@¡@¡@¾Ç¸¹¡B½Ò¦W
a01¡@¡@¡@¡@a01¡@°ê¤å
a02¡@¡@¡@¡@a01¡@^¤å
a03¡@¡@¡@¡@a02¡@^¤å
¡@¡@¡@¡@¡@¡@a02¡@¾ú¥v
¡@¡@¡@¡@¡@ ... |
¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
Bruce Lin
¦^ÂÐ: 5
Æ[¬Ý: 5497
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¥|¤ë 15, 2015 8:58 am ¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
** VARIANT_BOOL GetGeneralLogDataStr(
**
ì¨Ó¦p¦¹¡A¦A¦¸·PÁ¸Ѵb~ ^^ |
¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
Bruce Lin
¦^ÂÐ: 5
Æ[¬Ý: 5497
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¥|¤ë 15, 2015 8:36 am ¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
** VARIANT_BOOL GetGeneralLogDataStr(
**
vItem = TRANSFORM(idwEnrollNumber) + " ";
+ TRANSFORM(idwVerifyMode) + " ";
+ TRANSFORM(idwInOutMode) + " ";
+ sTime
sTime¨ú¥X¬O¦r¤¸«¬ºA ... |
¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
Bruce Lin
¦^ÂÐ: 5
Æ[¬Ý: 5497
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¥|¤ë 14, 2015 4:56 pm ¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
¤p§Ì°Ñ¦ÒVBªº¼gªk¡A¼g¥X¥H¤UªºCODE¡A¦ý¨ú¥X¨ÓªºÈ¡A³£¬OªÅ¥Õªº.... ¬OþÃ䦳¼g¿ù¶Ü? ·Ð½Ð«e½ú¨ó§U¡A·P¿E¤£ºÉ¡C
************************************
axCZKEM1 = CreateObject("zkemkeeper.ZKEM.1")
aa = A ... |
¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï.... |
Bruce Lin
¦^ÂÐ: 3
Æ[¬Ý: 3876
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¥|¤ë 13, 2015 11:56 am ¥DÃD: ¤º«Ø¨ç¼Æ¡G¾ã¦C½Æ»s¡B¶K¤W¡A§Ñ°O¨ç¼Æ¦WºÙ¨D±Ï.... |
§Anªº¬O³oÓ¶Ü?
SCATTER MEMVAR MEMO
APPEND BLANK
GATHER MEMVAR MEMO |
¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
Bruce Lin
¦^ÂÐ: 5
Æ[¬Ý: 5497
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¥|¤ë 13, 2015 9:45 am ¥DÃD: ¨D§U¡Adll¨ç¼Æªº¨Ï¥Î¤è¦¡¨D±Ð |
¤p§Ìªñ´Á¶R¤F¤@¥x³]³Æ¡A¼t°Ó¦³ªþdllªº»¡©ú¤ÎVB¡BC#ªº½d¨Ò¡A¦ý¨S¦³VFP½d¨Ò¡A¤p§Ì¨Ï¥ÎVFP6.0 ¡A¦]¥H«e¨S¥Î¹Ldll¡A©Ò¥H¤£ª¾¦p¦ó©I¥s¡A½Ð¦U¦ì«e½ú«ü¾É¡AÁÂÁÂ
¥Ø«e¸I¨ìªº°ÝÃD¡A¬O¤£ª¾±N³]³Æ¸Ì±ªº°O¿ý¨ú¥X¡Adll¤¤ªº¨ç ... |
¥DÃD: ¨D±Ï - Formªí³æµLªk½s¿èקï,¦p¦ó¸Ñ¨M?? |
Bruce Lin
¦^ÂÐ: 2
Æ[¬Ý: 5094
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤K¤ë 02, 2006 3:53 pm ¥DÃD: ¨D±Ï - Formªí³æµLªk½s¿èקï,¦p¦ó¸Ñ¨M?? |
½Ð°Ýfoxtoole¬O«ç¼Ëªº¤u¨ã©O ?
±qþÃä¥i¥H±o¨ì³oÓ×´_¤u¨ã©O?
·P¿E¤£ºÉ~ |
¥DÃD: ¨D±Ï - Formªí³æµLªk½s¿èקï,¦p¦ó¸Ñ¨M?? |
Bruce Lin
¦^ÂÐ: 2
Æ[¬Ý: 5094
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤K¤ë 02, 2006 11:18 am ¥DÃD: ¨D±Ï - Formªí³æµLªk½s¿èקï,¦p¦ó¸Ñ¨M?? |
¦]¹q¸£·í¾÷,ק襤ªºªí³æ,¦Û«¶}¾÷¤§«á,±ý«·s½s¿èקï,µ²ªG´N¦A¤]¥´¤£¶}¤F,
°õ¦æ¸Óªí³æ®É, VFP¨t²Î¼u¥X "¤£¬O¤@Ó¸ê®Æªí®æ" °T®§.
½Ð°Ý¦U¦ì¤j¤j,n¦p¦ó¤~¯à±Ï¦^ªí³æ©O?
·P¿E¤£ºÉ~ |
¥DÃD: ¦p¦óŪ¨ú¤å¦rÀÉ©O |
Bruce Lin
¦^ÂÐ: 2
Æ[¬Ý: 6409
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¥|¤ë 21, 2005 2:50 pm ¥DÃD: ¦p¦óŪ¨ú¤å¦rÀÉ©O |
·PÁ«e½ú¦^ÂÐ,°ÝÃD¸Ñ¨M¤F~ |
|