|
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 |
wangeve
µù¥U®É¶¡: 2005-08-01 ¤å³¹: 20
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤K¤ë 05, 2005 2:21 pm ¤å³¹¥DÃD: ½Ð°Ý¦bVFP¤¤¬O§_¦³·í·s¼W®É·|IJµoªº¨Æ¥ó |
|
|
½Ð°Ý¦bVFP¤¤¬O§_¦³·í·s¼W®É·|IJµoªº¨Æ¥ó |
|
¦^³»ºÝ |
|
|
marvin
µù¥U®É¶¡: 2004-06-01 ¤å³¹: 321
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 10:48 am ¤å³¹¥DÃD: |
|
|
STORE PROCEDURE ? yes |
|
¦^³»ºÝ |
|
|
wangeve
µù¥U®É¶¡: 2005-08-01 ¤å³¹: 20
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 11:33 am ¤å³¹¥DÃD: |
|
|
Stroe Procedure¬O«ü¸ê®Æ®w¸ÌªºªF¦è
§Ú«üªº¬O¦bVFP¤¤,grid±±¨î¶µ¤¤ªº¨Æ¥ó |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4214 ¨Ó¦Û: Taipei,Taiwan
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 11:43 am ¤å³¹¥DÃD: |
|
|
¦U®aª«¥ó³]p¤£¤@¼Ë.
´N¬O³o»ò²³æ.
free table ¤£»Ýnª¾¹D¦ó®É¥i¥H©Î¦ó®É¤£¥i¥H·s¼W°O¿ý,
¶Ç²Îªºfree table ¾Þ§@´N¬O³o¼Ë.
dbc ¦³ insert trigger ¥i¥H±±¨î¸Ó«ç»ò·s¼W,
¦ý¬O³£»P¦p¦óÅã¥ÜµLÃö.
¦Ü©ógrid,
¹ïvfp¨Ó»¡,¨º¨Ç¬O¥Î¨ÓÅã¥Ü¸ê®ÆªºªF¦è,
¤£»ÝnºÞ¸ê®Æ«ç»ò³B²z.
¥Î¨ä¥L¤u¨ãªº·§©À¨Ó¼gvfp,
«OÃÒ¸£µ¬¥´µ²¤F³£§@¤£¦n.
§Y«K¨ä¥L¤u¨ã,gridµ¥Åã¥Ü¸ê®Æª«¥ó¤]¤£»Ýnª¾¹D¤°»ò®ÉÔn«ç»ò³B²z¸ê®Æ. _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
wangeve
µù¥U®É¶¡: 2005-08-01 ¤å³¹: 20
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 12:36 pm ¤å³¹¥DÃD: |
|
|
§Ú²{¦b¦³¤@¨ÇÄæ¦ì,»Ýn¦b·s¼Wªº®ÉÔ°µ³B²z,
¨Ò¦p:¦³¤@ÓÄæ¦ì¬O¬y¤ô¸¹,§Ú·Qn¦b·s¼W®É,´N¥h¥[1Ó¸¹½X,
¨º¸Ó¼g¦b¨ºÓ¨Æ¥ó¤¤©O |
|
¦^³»ºÝ |
|
|
¤p¿à
µù¥U®É¶¡: 2004-12-27 ¤å³¹: 471
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 1:34 pm ¤å³¹¥DÃD: |
|
|
¨º§A¦p¦óIJµoÅý§Aªº¸ê®Æ·s¼W¸ê®Æ©O ? |
|
¦^³»ºÝ |
|
|
jms7275
µù¥U®É¶¡: 2005-01-08 ¤å³¹: 65
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 2:09 pm ¤å³¹¥DÃD: |
|
|
wangeve ¼g¨ì: | §Ú²{¦b¦³¤@¨ÇÄæ¦ì,»Ýn¦b·s¼Wªº®ÉÔ°µ³B²z,
¨Ò¦p:¦³¤@ÓÄæ¦ì¬O¬y¤ô¸¹,§Ú·Qn¦b·s¼W®É,´N¥h¥[1Ó¸¹½X,
¨º¸Ó¼g¦b¨ºÓ¨Æ¥ó¤¤©O |
À³¸Ó¬O¨S¦³, ¦ý¥i¥H¦Ûq¤@Ó¤èªkµ{§Ç¥h³B²z |
|
¦^³»ºÝ |
|
|
wangeve
µù¥U®É¶¡: 2005-08-01 ¤å³¹: 20
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 3:54 pm ¤å³¹¥DÃD: |
|
|
§Ú·Q½Ð°Ý ims7275 ,¨º¦Ûqªº¤èªkµ{§Çn¦p¦ó³B²z,
§Ú¬O«ü,¸Ó¦b¨º¤@Ó®ÉÂI¥h©I¥s³oÓ¤èªkµ{§Ç©O? |
|
¦^³»ºÝ |
|
|
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 9 ¼Ó
|
|
¦^³»ºÝ |
|
|
¤p¿à
µù¥U®É¶¡: 2004-12-27 ¤å³¹: 471
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 4:54 pm ¤å³¹¥DÃD: |
|
|
¤Þ¨¥¦^ÂÐ: |
¨º§A¦p¦óIJµoÅý§Aªº¸ê®Æ·s¼W¸ê®Æ©O ?
|
¦¶¥Sªº¬Ýªk´N¬O§Ú·Q»¡ªº ! |
|
¦^³»ºÝ |
|
|
sanchi
µù¥U®É¶¡: 2003-11-11 ¤å³¹: 61
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 5:00 pm ¤å³¹¥DÃD: |
|
|
Y¦bgrid,³]¦¨allowaddnew=.t.
«hactiveCell²¾¨ì·sªºªÅ¥Õrow®É
afterrowcolchange§PÂ_Y¬OªÅ¥Õ«h±N³Ì¤j¸¹¥[¤@¶ë¶i¥h |
|
¦^³»ºÝ |
|
|
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 12 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 5:04 pm ¤å³¹¥DÃD: |
|
|
¦pªG³o¼Ë
°h¤Æ¤@¤U¦p¦ó
°²³]µLªkÂǥѸê®Æ®w¤¤ªº¹wÀxµ{¦¡¨Ó§@
§Ú¤@ª½Ä±±o³o¼Ë§@¥u¬O¬°¤F¤À´²¦¡³B²z
¨º´N¥Ñfunction key ¨Ó§@
·í«ö¬YÓÁä¦sÀÉ«á,¤°»òªF¦è³£¼g¦bùØÀY¤F
¨ä¹êÁÙ¯à¼g¤°»òªF¦è
¤£´N¬O§â¿é¤Jªº¸ê®Æ¼g¨ì¸ê®Æ®w¤¤
¤]³\·í·s¼W¬Y±iªí³æ,¦Ón²§°Ê¨ä¥¦¬ÛÃöªºtable§a
¦pªG³o¼Ë°µ¹ê»Ú¤W¤S·|¦³©Ó»{¤Wªº°ÝÃD
¦L¥X¨Óªºªí³æ¤Sñ¦Wªºªí³æ,¤~¬O¯u¥¿ªºªí³æ(¯u¥¿¦³¥X³f,¶i³f¨ä¥¦²§°Ê³æ¾Ú)
¤£µM¥i¯àÁÙn¦h¥X¦n´XӰʧ@¨Ó³ø¼o³æ¾Ú(³æ¾Úªº§R°£°Õ,©Î¬O¥X±i¤Ï³æ¾Ú¨Ó˨R,¦³¨Ç¤HÁÙ¯u¬O¤°»òª¬ªp³£¦³)
§Úı±o°Õ!
³Ñ¤Uªº¥u¤£¹L¬O¿é¤J¹q¸£ªº¸ê®Æ
©Î¬O¬YÓcommand botton
³o¼ËÁ¿¦n¹³¤ñ¸û¹ê»Ú |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4214 ¨Ó¦Û: Taipei,Taiwan
²Ä 13 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 5:13 pm ¤å³¹¥DÃD: |
|
|
©Ò¥H»¡,¦pªG§A®³§Oªº¤u¨ãªº²ßºD¨Ó§@VFP,
´N·|¸£µ¬¥´µ².
§Oªº¤u¨ã·|¦bdataset,©Î¬O datacursorª«¥ó³]p¤@¨Ç¨Æ¥ó·í§@ trigger¨Ó¥Î,
¥i¬Ovfp¾Þ§@¸ê®Æ®É,¬O¤£¤Ó»Ýntriggerªº.
®³¥»¨Ò¨Ó»¡,
¦pªG¥Î delphi/BCB,«h¦bdataset·|´£¨Ñ onNewRecord ¨Æ¥ó,·í§@trigger,
©Ò¥H¦pªG·s¼W°O¿ý®É»Ýn§@¨Ç¤°»ò¹w³]È,
´N¥i¥H¦b³o¸Ì¼g.
¦ý¬Ovfp´N¤£»Ýn³o¼Ë,
§A¥i¥H¨Ï¥Î¦Ñ¤èªk:
¥N½X: |
APPEND BLANK
REPLACE Field1 with DefaultValue('Field1')
|
¤]¥i¥H¥Î·sªºinsert-sql:
¥N½X: |
insert into table1 (Field1) values (DefaultValue('Field1'))
|
¤]¥i¥H¨Ï¥ÎÄæ¦ì¹w³]Ȫº¤è¦¡:
¥N½X: |
alter table table1 set field1 default DefaultValue('Field1')
APPEND BLANK
|
³Ì«á¤@ºØ¤èªk±µªñ©óonNewRecord ¨Æ¥óªº°µªk,
©Ò¥H,VFP¨Ã¨S¦³¤]¤£»Ýn³]p¤@¨Ç¦³ªº¨Sªºªº¨Æ¥ó. _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
|
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 14 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤K¤ë 08, 2005 7:18 pm ¤å³¹¥DÃD: |
|
|
¨ä¹ê¤]§O¤p¬Ý¤F¥H«eªº¼gªk
¦³¨Ç¤H³z¹L°}¦C©M
²³æªº@......get......when......valid
¥[¤W¤@¨Çfor °j°é¥[¥H²Õ¦¨,
¥[¤W¤@¨Ç¥¨¶°
·Ó¼Ë¥i¥H§âform ¼g±o«Üº}«G
Åýµ{¦¡Åܱo«Ü¦n¼g
¨ä¹êwhen ´N¬Oªì³]ȤF
¥u¬O
¥DÃD¦n¹³¬O§â¸ê®Æ¿ý¦s¤J¨ìtable ùØ
·|µo¥Í¨ºÓ¨Æ¥ó(¤£.....ª¾......¹D)
°ÝÃD¬O
·í¸ê®Æ¤w¦s¤J¨ìtable ùؤF,ÁÙn§@¤°»ò
¥Hªí³æ¨ÓÁ¿,¦s¤J«á,´N¨S¨Æ¤F,°£«D...........
°¨¤W§@¤@¨Ç²§°Ê³B²z
¦A¸É¤@¤U
¦sÀɤ§«án°µ¨º¨Ç¨Æ±¡
¨Ì·Ó§Ú¥H©¹¼gªk,·|¼g¦b³Ì«á¤@ÓÄæ¦ìªºvalid |
|
¦^³»ºÝ |
|
|
catjoke
µù¥U®É¶¡: 2003-06-16 ¤å³¹: 175 ¨Ó¦Û: »´ä
²Ä 15 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤K¤ë 09, 2005 2:56 pm ¤å³¹¥DÃD: |
|
|
¼Ó¥D, °ÝÃD¨S¦³§A·Q¹³¤¤ªº³o»ò²³æ...
©¹©¹¤@Ó½s¸¹·| ÅÜ¥X´XÓ¤À¨!!!
¥H¤Uq³æ°µ¨Ò¤l, ¥»¨Ó «È¤á¤Uªºq³æ, ¥u¦³¤Q´Ú,
¨Ã¤wµo¥X¤F¹ïÀ³ªº±ÄÁʳ浹¤u¼t...
¦ý²{¦b¤S¥[¤F¤T´Ún¶R! ¨Ãn¨D ¦P®É¶¡¨«³f.....
½s¸¹¤W¥Î®a·|»{¬°¥½ºÝ¥[Ó A, B ·|¤À«K¤@¨Ç....
¨º§AÓ ½s¸¹·s¼W´N ¥´¸Ø¤F~
e.g.
PR0001
PR0002
PR0003
PR0004
PR0002A (²{¦b¥[³æ)
PR0005
PR0005A (¥t¤@±i ¤S¥[³æ)
PR0006
......
=> ¥X²{°ÝÃD:
§ä ¶¶±Æ«áªº³Ì«á½s¸¹: PR0004 ->
µ¹½s¸¹¬° PR0005 (¦ý¥Î®a§ï¬°¥[³æ: PR0002A)
¥t¤@Ó±¡ªp:
§ä ¶¶±Æ«áªº³Ì«á½s¸¹: PR0005A ->
µ¹½s¸¹¬° PR0006 (°O±o§â¥½ºÝªº A, B, C.... ±þ±¼¤~§ä¤U¤@Ó¬y¤ô¸¹!)
¦Ó¥B, ¤£¨¬ªº¦ì¸mn«O²K "0" ¤~¥i¥H¦¨¬°¬y¤ô¸¹...
¤£¬O¶Ã¥X¤@Ó PR7 ´N¥i¥H¨Ï¥Î!
n°t¦X¹ê»Ú¥«³õ¥Î³~, ¦Û¤vnªá¤ß«ä¼g¤@Ó ¦Û©w¨ç¼Æ¨Ó¸Ñ¨M¬O¥²¶·ªº¤u§@!!
¼g¤@Ó: GETNEWKEY(oldkey) ªº¨ç¼Æ,
¥¦n¤À¿ë ¦³¦h¤Ö¬O«D¼Æ¦r ¦rÀY: PR1234 => PR1235
¥çn°£¨«¥½ºÝªº«D¼Æ¦r¦r¦ê: P0235-2 => P0236
ÁÙ¬O¥¿½T¦a¸É²K "0": SG00005A => SG00006
¼g¤F¤@Ó«á, ¨º´N¬Æ»ò table ¤]¥Î¥¦pºâ¤U¤@Ó¬y¤ô¸¹....
°ÝÃDÅܦ¨ §ä¨ì "³Ì«áªº¬y¤ô¸¹", ¥Ñ©ó¨CÓ table ªº¶¶±Æ³W«h¤]¤£¦P, ¦ý¤£¼vÅT¹B§@! _________________ ØpØ{~ ¿ß·íµM¬O "T" ªº¹À! ^0^; |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|