½Ð°Ý¸ê®Æ¦Û°ÊÂà¶K¨ì«ü©w¦ì¸mªºµ{¦¡¦p¦ó¼gªk
- ©«¤l
- 51
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2023-5-8
|
½Ð°Ý¸ê®Æ¦Û°ÊÂà¶K¨ì«ü©w¦ì¸mªºµ{¦¡¦p¦ó¼gªk
¥»©«³Ì«á¥Ñ pcwh3 ©ó 2011-11-26 00:02 ½s¿è
1. ¹Ï¤¤¤W¥b³¡¥÷(ºñ¦â©³)¬°¤Jܮɪº¸ê®Æ¿é¤J°Ï.
2. ¤U¥b³¡¥÷«h¬°¦¹¤@LOTNOªº¥X³f°O¿ý, ¦³¨ÇLOTNO·|¤@¦¸©Ê¥þ³¡¥X³f¡A¦³¨Ç·|¤À¼Æ¦¸¥X³f.
3. §Ún°µ¨ì·í¦b"¥Xܤé´Á"¤¤¿é¤J¤é´Á¡G
3.1 ¦pªG¬O¤@¦¸©Ê¥X³f©Î²Ä¤@¦¸¥X³¡¥÷³f(¤À³f)¡Aºñ¦â³¡¥÷¬Û¹ïÀ³¸ê®Æ·|¦Û°Ê¶ñ¤J.
3.2 ¦pªG¬O²Ä¤G¦¸©Î¤§«áªº¥X³f¡A«h¤W¤@¦¸¦U¶µµ²¾l(BALPKG, BALCTN¤ÎBALCBM)»Ý¦Û°Ê«þ¨©¨ì¥»¦¸
¥X³fªº¥ª¤è¬ÛÀ³¦ì¸m¡A¦p¥H¤U¨Ò¤l.
½Ð°Ý¦p¦ó¼gµ{¦¡¥H¹F¨ì¥H¤Wn¨D.
|
-
-
DEMO.zip
(223.53 KB)
|
|
|
|
|
|
- ©«¤l
- 116
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 190
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2002
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-11-17
- ³Ì«áµn¿ý
- 2024-10-27
|
¦^´_ 1# pcwh3
°ÝÃD¤£¬Æ²z¸Ñ,¿é¤J¥Xܤé´Á«á,¦AÂI¤À³fÄæ¦ì¶Ü,¦pªG¬Oªº¸Ü,µ²¾lªº¼Æ¶q°O¿ý¦b¨º?°²³]¦³¤»½c,¤À³f¥X¤G½c,µ²¾l¥|½c¦b¦ó³B¬ö¿ý |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2023-5-8
|
¥»©«³Ì«á¥Ñ pcwh3 ©ó 2011-11-26 12:51 ½s¿è
¦^´_ 2# aa7551
·í¬Y¤@¤Ñ¦³·s³æ¤Jܤ§«á,«K¦b¤Jܳ¡¥÷¿é¤J¸ê®Æ,µM«áÀx¦s°_¨Ó.
¤é«án¥X³f,«K¦b¤U¤è¶i¦æ¥X³f¸ê®Æ¿é¤J.
¤@¦¸©Ê¥X³fªº¸Ü:-
¦pªG¬O¤@¦¸©Ê¥þ³¡¥X³f,«h¦b²Ä¤@¦æ¿é¤J¥X³f¤é´Á,¤§«á, ¶i³fªº¬ÛÃö¸ê®Æ«K¦Û°Ê¸ü¤J¥ª¤è¦ì¸m; ¥k¤è¨ä¥¦¬ÛÃö¸ê®Æ¤â°Ê¿é¤J;
¤À§å(³¡¥÷)¥X³fªº¸Ü:-
¦pªG²Ä¤@¦¸¥X³f¬O³¡¥÷¥X³f, ·í¦b²Ä¤@¦æ¥X³f¤é´Á¤¤¿é¤J¤é´Á¤§«á, ¥ª¤è¬ÛÃö¸ê®Æ¥çn¨D¦Û°Ê±a¤J, ¥k¤è¸ê®Æ¤H¤â¿é¤J¤§«á, BALPKG, BALCTN¤ÎBALCBM¥ç·|¦Û°Êp½c;
²Ä¤G¦¸¥X³f®É, ·í¦b²Ä¤G¦æ¥X³f¤é´Á¤¤¿é¤J¤é´Á¤§«á, ²Ä¤@¦æ¥k¤èBALPKG, BALCTN¤ÎBALCBM¼Æ¦rn¨D¦Û°Ê±a¤J²Ä¤G¦æ¥k¤è¬ÛÃö¦ì¸m;
¦pªG¬On¤À³f(©î³f, ·N«ä¬O¥Ñ¤@PKGÅܬ°¨âөΧó¦hªºPKG), ¦b©î³fRADIOBUTTONç¿ï, ¤§«á, ²Ä¤G¦æ¥ª¤èªºPKG¤ÎCARTON¬ÛÃö¸ê®Æ¤¹³\¤â°Ê§ó§ï, ¦ÓCBM«h¤´µM¤£·|ÅÜ°Ê(¥i¯à§AÌ·|«Ü©_©Ç¡A¼W¥[¤FPKG¤ÎCARTON¼Æ¶qÀ³¸Ó·|¦P®ÉÅÜ°ÊCBM¼Æ¦r, ¦ý¹ê»Ú¹B§@®É§Ṳ́£¤¹³\).
¦p¦¹Ãþ±À.
²{®É¥X³f°O¿ý³¡¥÷, ¨C¤@Ó¸ê®Æ¥u¯à¥H¤â°Ê¿é¤J, §Æ±æ¥i¥H¦Û°Ê¿é¤J, ¥H´î§C¸ê®Æ¿é¤J¿ù»~ªº¥i¯à©Ê.
¦¹ACCESS¨ä¥¦³¡¥÷¤´¦b«Ø³]¤¤. |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2023-5-8
|
¦^´_ aa7551
·í¬Y¤@¤Ñ¦³·s³æ¤Jܤ§«á,«K¦b¤Jܳ¡¥÷¿é¤J¸ê®Æ,µM«áÀx¦s°_¨Ó.
¤é«án¥X³f,«K¦b¤U¤è¶i¦æ¥X³f ...
pcwh3 µoªí©ó 2011-11-26 12:26
¸É¥R:
¤£¤@©wn¨D¦b[¥X³f¤é´Á]¤¤¿é¤J¤F¸ê®Æ«KIJ°Ê¸ê®Æ¦Û°Ê¿é¤J¨ìn¨Dªº«ü©w¦ì¸m, ¥i¥H¦b¬Y¤@¦ì¸m°µ¤@Óbutton¥h±Ò°Ê°õ¦æ, ©Î¨ä¥¦¤èªk.
§Æ±æ¦U¦ì¤j¤jÀ°¦£¤@¤U. |
|
|
|
|
|
|
- ©«¤l
- 116
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 190
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2002
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-11-17
- ³Ì«áµn¿ý
- 2024-10-27
|
¦^´_ 4# pcwh3
¤j¤jì©l³]p²z©À¬O¬O¥ÎNECOUTSTOCK_QUERY¨ÓpºâBALPKG, BALCTN¤ÎBALCBM¬O¶Ü?¿é¤J«á»Ý°µrefresh¤~¯à¬Ý¨ì¸ê®Æ,©Ò¥H·Q´«Ó¤èªk°õ¦æ |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2023-5-8
|
¦^´_ pcwh3
¤j¤jì©l³]p²z©À¬O¬O¥ÎNECOUTSTOCK_QUERY¨ÓpºâBALPKG, BALCTN¤ÎBALCBM¬O¶Ü?¿é¤J«á»Ý°µrefr ...
aa7551 µoªí©ó 2011-11-28 12:34
1. ¥»ACCESS·|ºÞ²z¤TÃþ¤£¦PÃþ«¬ªº³æ:-
1.1 NEC1111-123TH(¨Ò¦p) - ¦¹Ãþ³æ¬O¶¶§Ç¨ú³æ¸¹, «ö¨ì³f®É¶¶§Çµ¹¤©¡C
¦]¨C¤ën¥Ñ001«·s¶}©l, ¬G¤£¯à¥Ñ¨t²Î¦Û°Ê½s¸¹¡C
¦Ó¦bNECDATAINPUTªí¤¤¦³¤@«ö¶s[§ó·s¸ê®Æ], ·í«ö¤U®É, ¦¹ªí¤¤³Ì¥k¤è
[NON SPICE³æ±Æ§Çªí«K·|¦Û°Ê§ó·s, Åý¨Ï¥ÎªÌª¾¹D²{®Én¨úªº¤U¤@Ó½s¸¹
¬O¬Æ»ò¡C¦¹ACCESS¤é«á¬O·|¦h¤H¨Ï¥Î¡C
1.2 NEC1111-5XXXTHV(¨Ò¦p) - ¦¹Ãþ³æ¬O¨Ó³æ®É«K¤w¦³¡A¥un«ö³æ¸¹¿é¤J«K¥i.
1.3 LXXXXXXX(¨Ò¦p) - ¦P1.2¤@¼Ë.
2. NECOUTSTOCKQFM¬O¿é¤J¥X³f¸ê®Æ¤§¥Î, »PNECDATAINPUTªí¤¬¦³³sµ².
2.1 §Ú·Q¦bNECDATAINPUT¤¤¿é¤J¤F¸ê®Æ¤§«á¡A³¡¥÷¸ê®Æ·|¦Û°ÊÂà¤JNECOUTSTOCKQFM¤¤,
¥H«K©ó¥X³f®É¥i¥Hª½±µ¨ú¥Î.
2.2 ¦ý¦]¬°¥X³f·|¦³¥H¤U¥i¯à©Ê¡G-
2.2.1 ¥þ³æ¥þ³¡¥X³f - §Y³æ¤¤¥þ³¡³f«~¤@¦¸©Ê¥X³f;
2.2.2 ³¡¥÷³f§¹¾ã¥X³f - §Y¨Ò¦p¥þ³æ¦@3 CTN, ¥u¥X³f1 CTN;
2.2.3 »Ýn¥Ñ1 PKG©Î1CTN¤¤©â¥X³¡¥÷PCS(©î³f©Î¥s°µ¤À³f)¡A¥Î¤@Ó·sªº½c¸Ë°_¥X³f¡A
§Y¥Ñ1CTNÅܬ°2CTN(¨Ò¦p);
¦¹µ¥©î³f©Òl¥Í¥Xªº·s½c¡A§Ṳ́£¥Î«·sp½c¨äCBM, ¥u»Ý¤â°Ê±N¨äPKG¤ÎCTN¼ÆÅܧó«K¥i.
3. NECOUTSTOCKQFM¤¤OUTCBM¡BBALPKG¡BBALCTN¤ÎBALCBMªº¼Æ¦r, ¥ç»Ýn±a¨ìNECOUTSTOCK¸ê®Æªí¤Î
OUTSTOCK_QUERY¬d¸ß¤¤¡A²{®É¤£ª¾¦p¦ó¤~¥i¥H°µ¨ì.
²{®É¸£µ¬·Q±o¹ê¦º¤F¡AÂण¤FÅs¡C¬G¦V¦U¦ì±Ï±Ð¡C |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2023-5-8
|
¦^´_ 6# pcwh3
²{¦b¨Ï¥Î¤FSQL¤¤ªºINSERT INTO SELECT FROM°µ¨ì¤F·í¦bINDATAªí¤¤¿é¤J¸ê®Æ¤§«á, «ö½T»{«ö¶s«K¥i±N¸ê®Æ±a¨ìOUTDATAªí¤¤, ¦ý¤´¦³¨ä¥¦°ÝÃD¥X²{.
¨Ò¦p:
1. ¨C¤@¦¸¿é¤J§¹¤§«á, ³£·|±N¾ãÓINDATA¸ê®Æ¥þ³¡¼g¤J¤@¦¸(¤w¨î¤F«Âжµ¥Ø¤£¦A¼g¤J,) ¦ý¤´·|¼u¥Xµ¡¤f³qª¾, ¤£ª¾¦p¦ó¨î¦¹µ¥µ¡¤f³qª¾¤£¦A¥X²{.
2. ·í²Ä¤@¦¸¤À©î¥X¶U¤§«á,¦p¦ó±NBALPKG, BALCTN, BALCBM±a¨ì¤U¤@RECORD ·í§@¸ÓRECORDªº·sªºINDATA¸ê®Æ¨Ñ²Ä¤G¦¸¥X³f®É¦©¼Æ¤§¥Î;
3. ·íBALPKGµ¥¬°0(¹s)¤§®É, ¦p¦óªý¤î¥Î¤á¸Õ¹Ï¦b·sªºRECORD¤¤Ä~Äò¶i¦æ¥X³f¿é¤J.
¥¿¦b§V¤O§ä´Mµª®×.
¦U¦ì¤j¤j¦³ªÅªº¸Ü¥ç§Æ±æÀ°¤@§â. ÁÂÁÂ. |
|
|
|
|
|
|