|
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 |
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 408
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤G¤ë 01, 2019 10:22 am ¤å³¹¥DÃD: ¦h¤Hª©¦p¦ó±±¨îªí³æ¯àÁ䦳¤H¨Ï¥Î¤¤¨ä¥L¤H¤£¯à¨Ï¥Î,½Ð±Ð¦U¦ì¥ý¶i |
|
|
¦p¼ÐÃD
¦h¤Hª©,·í¦³¤@ªí³æ¥\¯àÁ䦳¤H¦b¨Ï¥Î®É,¨ä¥L¤HûµLªk¨Ï¥Î |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2158
²Ä 2 ¼Ó
|
|
¦^³»ºÝ |
|
|
CPS0204
µù¥U®É¶¡: 2014-08-24 ¤å³¹: 451
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 04, 2019 1:33 pm ¤å³¹¥DÃD: |
|
|
½Ð°Ý:¤°»ò¬O (ªí³æ¥\¯àÁä) ,ªí³æ¶Ü? ¥\¯àÁä f1-f12¶Ü?
¨âªÌ²Õ¦X¬O¤°»ò? |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 04, 2019 9:54 pm ¤å³¹¥DÃD: |
|
|
§Ú¬Oı±o¥ý·Q²M·¡¬°¤°»ò¦A»¡«ç»ò°µ, _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 408
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 05, 2019 11:12 pm ¤å³¹¥DÃD: |
|
|
ÁÂÁ¼ӤW¦U¦ì¥ý¶i¦^ÂÐ..§Úªºì·N¬O.ªí³æ¤W³]©w¤@ÓcommandÁä,§Æ±æ³ocommandÁä¦b¦³¤H¨Ï¥Î©|¥¼ÄÀ©ñ®É.¨ä¥L¤H¤£¯à¨Ï¥Î.«ÂI¦b©ó·í¦³¤H¿é¤J¦Û°Ê¥H³sÄò¥N¸¹¦s¤Jªº¼Æµ§¸ê®Æ®É.Y¦³¨ä¥L¤H¤]¨Ï¥Î¦¹¥\¯àÁä®É.¥²³y¦¨§Ç¸¹«½Æ©Ò¥H¤~¦³¦¹¤@»Ý¨Dªº³]p..
½Ð¦U¦ì¥ý¶i¤£§[«ü±Ð.¹Ø¤]¯¬ºÖ¦U¦ì..·s¬K´r§Ö.. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 06, 2019 12:45 am ¤å³¹¥DÃD: |
|
|
³o¬O¤@ºØÀ³¸Ó·|³Q°v¦bÀð¤WM¤ÑN©]ªº·Qªk _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
perry
µù¥U®É¶¡: 2014-07-20 ¤å³¹: 203
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 06, 2019 12:14 pm ¤å³¹¥DÃD: |
|
|
¸Õ¸Õ!!
«Ø¤@Ó¦@¥Î¸ê®Æ§¨
proc cmd1.click
priv cmdus_tf
cmdus_tf=.T.
on error do cmdmsg
sele 0
cera dbf ¦@¥Î¸ê®Æ§¨.cmdused (mark c(1))
on error
if !cmd_ustf
retu &&§O¤H¨Ï¥Î¤¤
endi
.
.
.
use in ¦@¥Î¸ê®Æ§¨.cmdused
endproc
proc cmdmsg
cmdus_tf=.F.
retu |
|
¦^³»ºÝ |
|
|
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 408
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 06, 2019 4:24 pm ¤å³¹¥DÃD: |
|
|
·PÁÂSyntech¤j¤j PERRY¤j¤j..¦³·Q¹Lp¤jªº¤è¦¡.¥u·Qª¾¹D¬O§_¦³¨ä¥L¤è¦¡..ÁÂÁ¨â¦ì.. |
|
¦^³»ºÝ |
|
|
yctsai
µù¥U®É¶¡: 2003-04-11 ¤å³¹: 179
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤G¤ë 09, 2019 10:08 am ¤å³¹¥DÃD: |
|
|
³oÀ³¸Ón«ä¦Ò§Ç¸¹¤£«ÂЪº¤èªk
¦ý¬O¤è¦V¤W¤£¯à·Q«ö¶s¤£¯à«ö§a
§Ú·|³]p±±¨îÀÉ,§ì¨ú¥Ø«eÈ,¦^¼g+1,2¥x¦P®É§ì¨úªº¾÷·|,´X¥G¬°0,¦Ü¤Ö¨S¹J¹L
«OÀI°_¨£,§ì¨ú§Ç¸¹+¶Ã¼Æ |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤G¤ë 10, 2019 12:07 am ¤å³¹¥DÃD: |
|
|
§Úªº¤èªk»¡Â²³æ¤]«Ü²³æ,
·Q¿ìªk»s³y¤@Ó"¿ù»~",
´N¥i¥H®·®»(catch)³oÓ¿ù»~°µ«áÄò·s¸¹½Xªº³B²z.
³oÓ°µªk¦b¥u¦³dbaseªº®É¥N´N¦³¤F,
ºô¸ô¤W°Q½×¤ñ¶Ç»¡¤¤ªº"¬õª°"ÁÙn¦A¦.
¨S¦³¤°»ò 99.999..........% ªº¦¨¥\²v,
´N¬O100% _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤K¤ë 25, 2019 9:43 pm ¤å³¹¥DÃD: |
|
|
jtcom01 ¼g¨ì: | ÁÂÁ¼ӤW¦U¦ì¥ý¶i¦^ÂÐ..§Úªºì·N¬O.ªí³æ¤W³]©w¤@ÓcommandÁä,§Æ±æ³ocommandÁä¦b¦³¤H¨Ï¥Î©|¥¼ÄÀ©ñ®É.¨ä¥L¤H¤£¯à¨Ï¥Î.«ÂI¦b©ó·í¦³¤H¿é¤J¦Û°Ê¥H³sÄò¥N¸¹¦s¤Jªº¼Æµ§¸ê®Æ®É.Y¦³¨ä¥L¤H¤]¨Ï¥Î¦¹¥\¯àÁä®É.¥²³y¦¨§Ç¸¹«½Æ©Ò¥H¤~¦³¦¹¤@»Ý¨Dªº³]p..
½Ð¦U¦ì¥ý¶i¤£§[«ü±Ð.¹Ø¤]¯¬ºÖ¦U¦ì..·s¬K´r§Ö.. |
¨t²Îº¥ýn¦³¤@ÓÀˬd½X(Y¥i¥Î/N¤£¥i¥Î)!!
·í¦³¤H¨Ï¥Î´N¦s¤J³oÓÀˬd½X(N)ùØÀY
¨ä¥L¤Hn¥Î®É´N´N¥h§PÂ_¬O§_¥i¥H¥Î....
°£«D³oÓ¤H,½T©w¥Î§¹,¨º»òÀˬd½X(Y) ¦A¦¸°µ§ó·s _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
CPS0204
µù¥U®É¶¡: 2014-08-24 ¤å³¹: 451
²Ä 12 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 26, 2019 4:39 pm ¤å³¹¥DÃD: d |
|
|
¨ä¹êµo¤åªÌ¥u¬On
·íºô¸ô¦h¤H³sÄò¿é¤J®É,¨ä¥Lªº¤H¤£n´¡Â_¤]¼g¤J¬Û¦Pªº¸¹½X
¸ò ,ªí³æ«ö¯Ã¨S¦³Ãö«Y!
½Ð°Ýµo¤åªÌ:
§Aªº°ÝÃD¬O1©Î2
1.·í¦³¤H³sÄò¿é¤J10µ§®É,§O¤Hµ´¹ï¤£¥i¦û¥Î¦¹10Ó³sÄò¬y¤ô¸¹,ª½¨ì²Ä¤@Ó¤H«ö¿é¤J§¹³¬®É¤~¯à§@·~
2.·í¦³¤H³sÄò¿é¤J10µ§®É,¨ä¥L¤H¤]¥i¥H¦P®É·m¸¹,¦ý¬O¤£«ÂЬ°ì«h,¦h¤H¥i¦P®É·s¼W¦sÀÉ! |
|
¦^³»ºÝ |
|
|
jtcom01
µù¥U®É¶¡: 2005-07-29 ¤å³¹: 408
²Ä 13 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤K¤ë 29, 2019 12:48 pm ¤å³¹¥DÃD: |
|
|
CPS0204¥ý¶iÁÂÁ±zªº¦^ÂÐ..§Úªº°ÝÃD»Ý¨D¦b1. |
|
¦^³»ºÝ |
|
|
andywilliams
µù¥U®É¶¡: 2004-10-23 ¤å³¹: 111
²Ä 14 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤K¤ë 30, 2019 2:45 am ¤å³¹¥DÃD: |
|
|
§AÀ³¸Ó§âµ{¦¡¼g¦¨¡u·|±Æ¶¤¡v,RLOCK(),UNLOCK ¥iÀ°§A¹ê²{.
ªí³æ¥i¦h¤H¦P®É¨Ï¥Î,¦ý¼g¤J¸ê®Æ®É(¦³°ß¤@½s¸¹ªº)´N±o±Æ¶¤
«Ø¥ß¤@Ódbf,Àx¦snlockªºÀɦW,¼g¤J¸ê®Æ®Én¥ýRLOCK()
PROCEDURE num_lock && Âê©w½s¸¹
LPARAMETERS Mdbf_name
...
Mlock = .F.
MtimeUp = 0
DO WHILE !Mlock .AND. MtimeUp < 5 .AND. !EOF()
Mlock = RLOCK()
IF Mlock
EXIT
ENDIF
INKEY(1)
MtimeUp = MtimeUp +1
ENDDO
RETURN(Mlock) |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 15 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤K¤ë 30, 2019 2:13 pm ¤å³¹¥DÃD: |
|
|
§Ú¬O³o¼Ë·dªº.
§ä¤@ÓTABLE1,¨ä¤¤FIELD1 ¬O¥Î¨Ó®Ö¹ï°ß¤@ȪºÄæ¦ì,
«Ø¥ß CANDIDATE ¯Á¤ÞÀÉ <=== ¤£¬O UNIQUE, ¥i¥H¥h¬dUNIQUE ªº¥Îªk
¥N½X: |
INDEX ON FIELD1 TAG INDEX_A CANDIDATE
|
«Ø¥ß ON ERROR ¨ç¦¡,³oÓ¤]¥i¥H¥Îª«¥óªºERROR¨Æ¥ó¥N´À
¥N½X: |
PUBLIC NOT_UNIQUE && Àˬd¬O¤£¬O°ß¤@
&& ¨t²Î¿ù»~³B²zPROCEDURE¡C
ON ERROR DO errHandler WITH ;
ERROR( ), MESSAGE( ), MESSAGE(1), PROGRAM( ), LINENO( )
PROCEDURE errHandler
PARAMETER merror, mess, mess1, mprog, mlineno
DO CASE
CASE MERROR = 1884 && ¯Á¤Þ¿W¤@©Ê³Q¥Û¥ÖÃa
NOT_UNIQUE = .T.
OTHERWISE
ENDCASE
ENDPROC
|
©Ò¥Hn´ú¸Õ¦³¨S¦³°ß¤@©Ê,
¥N½X: |
NOT_UNIQUE = .F.
INSERT INTO TABLE1 (FIELD1) VALUES ("XXXXXXX")
&& µo¥ÍINSERT¿ù»~®É,·|°õ¦æ errHandler ,§â NOT_UNIQUE §ï¬° .T.
IF NOT_UNIQUE
=MESSAGEBOX("¦¹¸¹½X¤w¦û¥Î")
ELSE
=MESSAGEBOX("¦¹¸¹½X¥¼¦û¥Î")
ENDIF
|
³oÓ¤èªk,¥un¨S¦³µwÅé°ÝÃD,¨Ò¦pDBF©ÎINDEXÃa±¼,
°»´ú²v´N¬O100%
¦pªGn·h¨ìSQL ¥h,
´N¬O«Ø¥ß¬°Primary Key,
¤@¼Ë¦bINSERT¿ù»~®É,VFP¥i¥H±µ¦¬¨ì¤@Ó¿ù»~,
¨º´N¥i¥H°»´ú°ß¤@©Ê
n¥Î¨ÓÅý¨ä¥L¤H¤£¯à¶i¥h¬Y¥\¯à,¥i¥H§â¥\¯à¥N¸¹¥á¶i¥h,
n¥Î¨ÓÅý¨ä¥L¤H¤£¯à¨Ï¥Î¬YºØ¥N¸¹,¥i¥H§â³f«~¥N¸¹,«È¤á¼t°Ó¥N¸¹,³æ¾Ú¸¹½X,µo²¼¸¹½X,....©ñ¶i¥h,
n¥Î¨ÓÅý¨ä¥L¤H¤£¯à¨Ï¥Î¬YÀɦW©Î¬O¸ê®Æ§¨¦W,À³¸Ó¤£»Ýn¥Î³oÓ.
·íµM«á±ÁÙn°µ«Ü¦h¤u§@,
¨Ò¦p²M°£TABLE1ªºÂ¸ê®Æµ¥µ¥ _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|