µoªí¤H |
¤º®e |
¥DÃD: §ì¨ú³Ì¤p¤é´Á©M³æ¸¹ |
jackqek
¦^ÂÐ: 5
Æ[¬Ý: 6348
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤»¤ë 30, 2006 11:55 am ¥DÃD: §ì¨ú³Ì¤p¤é´Á©M³æ¸¹ |
«á¨Ó§Ú§â¥L¤À¬q§ì
¥ý§ìa¡Bh¥X¡A¦A§ì4¥X¨Ó¡A¤GÓ¦A¦X¨Ö~~ |
¥DÃD: §ì¨ú³Ì¤p¤é´Á©M³æ¸¹ |
jackqek
¦^ÂÐ: 5
Æ[¬Ý: 6348
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤»¤ë 28, 2006 9:56 am ¥DÃD: §ì¨ú³Ì¤p¤é´Á©M³æ¸¹ |
½s¸¹
1
1
1
1
µ¥¯Å
A
A
H
4
²§°Ê¤é´Á
950318
950320
950321
950503
³æ¸¹
0
0
0
a0001
§Ú·Qn§ìªº¸ê®Æ¬O²§°Ê¤é´Á¬O³Ì¤pªº¦Ó¥Bµ¥¯Å¬OA¡A¦A§â¬O¦P¤@µ§½s¸¹ªº³æ¸¹§ì¶i¨Ó¡A¦X¨Ö±o¨ì¥ ... |
¥DÃD: sql»yªkµLªk¶ë¥X¥¿½TªºÈ |
jackqek
¦^ÂÐ: 4
Æ[¬Ý: 6430
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤»¤ë 28, 2006 9:45 am ¥DÃD: sql»yªkµLªk¶ë¥X¥¿½TªºÈ |
«á¨Ó¨Ï¥Î¤À¤G¬q§ì´N¦æ¤F¡AÁÂÁÂ~ |
¥DÃD: sql»yªkµLªk¶ë¥X¥¿½TªºÈ |
jackqek
¦^ÂÐ: 4
Æ[¬Ý: 6430
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤» ¤»¤ë 24, 2006 10:09 am ¥DÃD: sql»yªkµLªk¶ë¥X¥¿½TªºÈ |
·Q½Ð±Ð¤j®a¡A§Ú¦³¤T±itable
A table
ID name
1 ¤p¤ý
2 ¤p¥Õ
3 ¤p¶À
B table
ID enddate
1 950205
3 950305
3 950210
C table
ID enddate
1 950205
1 950305
3 950210
§Ú·Qn§ì B table ©M C ta ... |
¥DÃD: ½Ð°Ý¦p¦ó±NȶǨì³øªí |
jackqek
¦^ÂÐ: 4
Æ[¬Ý: 6034
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤¤ë 10, 2006 2:43 pm ¥DÃD: ½Ð°Ý¦p¦ó±NȶǨì³øªí |
§Ú¬O±N¤@ÓÅܼÆn¥á¨ìreport¡A¥Ø«e«Å§ipublic cost¡A´N¯à¤F¡AÁÂÁ§A |
¥DÃD: ½Ð°Ý¦p¦ó±NȶǨì³øªí |
jackqek
¦^ÂÐ: 4
Æ[¬Ý: 6034
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤¤ë 10, 2006 11:58 am ¥DÃD: ½Ð°Ý¦p¦ó±NȶǨì³øªí |
¨Ò¦p¡G§Ú±o¨ì¤F¤@ÓȬOCOST=1000¦Ó¥B¬O¼g¦bForms¸Ì
¡A¨º§Ú¦bReports(³øªí)¸Ìinsert control¤@ÓField¡AExpression¬°COST¡Aµ²ªGȧ䤣¨ì¡A½Ð°Ýn¦p¦ó¸Ñ¨M?ÁÂÁ |
¥DÃD: ¦p¦ó¤ñ¹ï¤G±itable¡A§ä¥X¥t¤@±itable¨S¦³ªºÈ |
jackqek
¦^ÂÐ: 3
Æ[¬Ý: 5498
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤¤ë 04, 2006 3:10 pm ¥DÃD: ¦p¦ó¤ñ¹ï¤G±itable¡A§ä¥X¥t¤@±itable¨S¦³ªºÈ |
lc_ala=ALIAS()
SELECT b.* FROM (lc_ptal) b WHERE b.S2VHNO NOT in (select a.p30903 FROM &lc_ala a ) INTO CURSOR lc_fi2
§ï¦¨³o¼Ë¡A§Ú´N¥i¥H¤F~ |
¥DÃD: ¦p¦ó¤ñ¹ï¤G±itable¡A§ä¥X¥t¤@±itable¨S¦³ªºÈ |
jackqek
¦^ÂÐ: 3
Æ[¬Ý: 5498
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤¤ë 04, 2006 9:52 am ¥DÃD: ¦p¦ó¤ñ¹ï¤G±itable¡A§ä¥X¥t¤@±itable¨S¦³ªºÈ |
lc_ptal=alias()
select (lc_ptal)
scan
lc_s2sscd=s2sscd
lc_sqcm=" SELECT P30901,P30902,P30903"
lc_sqcm= lc_sqcm + " FROM DMFLIB.DMPF309"
lc_sqcm= lc_sqcm + " where p30902=?lc_s2sscd"
ln_s ... |
¥DÃD: ¦p¦ó¤ñ¹ï¤G±itable¡A§ä¥X¥t¤@±itable¨S¦³ªºÈ |
jackqek
¦^ÂÐ: 3
Æ[¬Ý: 5498
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤¤ë 03, 2006 5:21 pm ¥DÃD: ¦p¦ó¤ñ¹ï¤G±itable¡A§ä¥X¥t¤@±itable¨S¦³ªºÈ |
A tableªºÄæ¦ì
name id
¤ý¤p©ú 1
±i¤jÀY 2
ªLªüªF 3
B tableªºÄæ¦ì
id addr
1 ¹ü¤Æ
2 ¥x¤¤
3 ¥x¥_
4 ®ç¶é
¤G±ijoin¡A§Ú·Qn¨ú¥Xid ¡Baddr ¬O4©M®ç¶é¡A½Ð°Ý§Ún«ç»ò¤U»yªk?
ÁÂÁÂ |
¥DÃD: sql«ü¥O¿ù»~ |
jackqek
¦^ÂÐ: 3
Æ[¬Ý: 5510
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤¤ë 01, 2006 6:44 pm ¥DÃD: sql«ü¥O¿ù»~ |
ì¨Ó¬O³o¼Ë°Ú¡A§Ú·|¸Õ¸Õªº¡AÁÂÁ§Aªºµª®× |
¥DÃD: sql«ü¥O¿ù»~ |
jackqek
¦^ÂÐ: 3
Æ[¬Ý: 5510
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¥|¤ë 28, 2006 3:57 pm ¥DÃD: sql«ü¥O¿ù»~ |
SELECT p4brch,p4ptno,p3ptnc,pabudt,paqty,p4oh,p4mvn,p4amt FROM DMFLIB.DGPM7 LEFT JOIN paflib.papapf ON p4brch=pabrch AND p4ptno=paptno INTO CURSOR lv_p4pa5 WHERE (pabudt BETWEEN lc_gc1 and lc_gc2) ... |
¥DÃD: cursor ¯àjoin¶Ü? |
jackqek
¦^ÂÐ: 19
Æ[¬Ý: 23315
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¥|¤ë 28, 2006 3:51 pm ¥DÃD: cursor ¯àjoin¶Ü? |
ì¨Ó¬O¹êÅétable¤£¯àjoin cursor¡A¤w´«§OºØ¤è¦¡¼g |
¥DÃD: cursor ¯àjoin¶Ü? |
jackqek
¦^ÂÐ: 19
Æ[¬Ý: 23315
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¥|¤ë 25, 2006 4:16 pm ¥DÃD: cursor ¯àjoin¶Ü? |
SELECT a.p4brch,a.p4ptno
FROM lv_p4pa4 a LEFT JOIN paflib.papapf b ON a.p4brch+a.p4ptno=b.pabrch+b.paptno INTO CURSOR lv_p4pa5
§Ú§â¥¦§ï¦¨¤W±ªº¡A«o¥X²{³oÓ°T®§¡A¦p¹Ï¡A
½Ð°Ýn«ç»ò¸Ñ¨M |
¥DÃD: cursor ¯àjoin¶Ü? |
jackqek
¦^ÂÐ: 19
Æ[¬Ý: 23315
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¥|¤ë 25, 2006 12:50 pm ¥DÃD: cursor ¯àjoin¶Ü? |
§Ú·Q½Ð°Ý¤j®a¡A¦p¤U¡G§Ú¥ýselect ¥X¨Ó±o¨ì ¤@µ§¸ê®Æ
SELECT * FROM lv_p4pa3 INTO CURSOR lv_p4pa4
¦A¨Ó§Ún¨Ï¥Î³oÓcursor lv_p4pa4 join ¹êÅ骺table
SELECT a.p4brch,a.p4ptno
FROM (lv_p4pa4) a ... |
¥DÃD: ºâ¥X¬Û®t¤Ñ¼Æ |
jackqek
¦^ÂÐ: 2
Æ[¬Ý: 4994
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤T¤ë 27, 2006 4:42 pm ¥DÃD: ºâ¥X¬Û®t¤Ñ¼Æ |
½Ð°Ý§Ún«ç»òºâ¥X20060327¨ì20060404¡A±o¨ì¤Ñ¼Æ¬O8¤Ñ¡A§Ún«ç»ò¼g©O?ÁÂÁ |
|