VFP ·R¥ÎªÌªÀ°Ï ­º­¶ 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¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

¦h¤Hª©¦p¦ó±±¨îªí³æ¯àÁ䦳¤H¨Ï¥Î¤¤¨ä¥L¤H¤£¯à¨Ï¥Î,½Ð±Ð¦U¦ì¥ý¶i
«e©¹­¶­± 1, 2, 3  ¤U¤@­¶
 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 408


²Ä 1 ¼Ó

µoªíµ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¨Ï¥Î
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
garfield
Site Admin


µù¥U®É¶¡: 2003-01-30
¤å³¹: 2157


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤é ¤G¤ë 03, 2019 10:04 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

http://vfp.sunyear.com.tw/viewtopic.php?t=6680
_________________
§Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙ­n§Ö±o¨ìµª®×.
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
CPS0204



µù¥U®É¶¡: 2014-08-24
¤å³¹: 441


²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤G¤ë 04, 2019 1:33 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

½Ð°Ý:¤°»ò¬O (ªí³æ¥\¯àÁä) ,ªí³æ¶Ü? ¥\¯àÁä f1-f12¶Ü?
¨âªÌ²Õ¦X¬O¤°»ò?
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 4 ¼Ó

µoªíµ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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 408


²Ä 5 ¼Ó

µoªíµ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§Ö..
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 6 ¼Ó

µoªíµ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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
perry



µù¥U®É¶¡: 2014-07-20
¤å³¹: 203


²Ä 7 ¼Ó

µoªíµ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
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 408


²Ä 8 ¼Ó

µoªíµ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¤è¦¡..ÁÂÁ¨â¦ì..
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
yctsai



µù¥U®É¶¡: 2003-04-11
¤å³¹: 179


²Ä 9 ¼Ó

µoªíµ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°_¨£,§ì¨ú§Ç¸¹+¶Ã¼Æ
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 10 ¼Ó

µoªíµ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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
ezpos



µù¥U®É¶¡: 2011-04-20
¤å³¹: 323


²Ä 11 ¼Ó

µoªíµ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¤H­n¥Î®É´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¥Í¬¡ºô
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ °ÑÆ[µoªí¤Hªº­Ó¤Hºô¯¸
CPS0204



µù¥U®É¶¡: 2014-08-24
¤å³¹: 441


²Ä 12 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤K¤ë 26, 2019 4:39 pm    ¤å³¹¥DÃD: d ¤Þ¨¥¦^ÂÐ

¨ä¹êµo¤åªÌ¥u¬O­n
·íºô¸ô¦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ÀÉ!
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 408


²Ä 13 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤K¤ë 29, 2019 12:48 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

CPS0204¥ý¶iÁÂÁ±zªº¦^ÂÐ..§Úªº°ÝÃD»Ý¨D¦b1.
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
andywilliams



µù¥U®É¶¡: 2004-10-23
¤å³¹: 111


²Ä 14 ¼Ó

µoªíµ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¦s­nlockªºÀɦ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)
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 15 ¼Ó

µoªíµ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



©Ò¥H­n´ú¸Õ¦³¨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,¥u­n¨S¦³µwÅé°ÝÃD,¨Ò¦pDBF©ÎINDEXÃa±¼,
°»´ú²v´N¬O100%
¦pªG­n·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­Ó. Laughing Laughing Laughing


·íµ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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
«e©¹­¶­± 1, 2, 3  ¤U¤@­¶
²Ä1­¶(¦@3­¶)

 
«e©¹:  
±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§@