¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
jeff2004
µù¥U®É¶¡: 2005-10-30 ¤å³¹: 27
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤G¤ë 18, 2006 7:51 pm ¤å³¹¥DÃD: ·s¤â½Ð±Ð¤p°ÝÃD........ |
|
|
§Ú¬O¤@Óvfpªº·s¤â....²{¦b¾Ç®Õ¦b±Ðxbase«ü¥O,·Q½Ð°Ý¤@¤U......«ç¼Ë¨Ï¥Îxbase«ü¥O¦bvfp¥[¤J¤@¦W·sŪªÌ"xxx"©O?
¬O¤£¬O¥u¦³¿é¤Jappend,¼u¥XªÅ°O¿ý¿é¤Jxxxªº¸ê®Æ³oÓ¤èªk?ÁÙ¦³§Oªº¤èªk¶Ü?
¥t¥~¦b#3¡B#4¸¹ÅªªÌ¶¡¥[¤J¤@·sŪªÌ
§Ú¿é¤Jªº«ü¥O¬O
go 3
insert
¦ý¬O¬°¬Æ»ò±o¥X¨Óªºµ²ªG¤£¬O¦b#3¡B#4¶¡¥[¤J¤@ŪªÌ,¦Ó¬O¥[¤F¦b³Ì«á©O?
±Ð§÷¤¤©Ò»¡
INSERT [ blank ]
¥H¤¬°Ê½s¿èª¬ºA¡AºòÀH«ü°w¤§«á¥[¤J¤@·s°O¿ý
Ãø¹D¤£¬Oªº¶Ü? |
|
¦^³»ºÝ |
|
 |
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤G¤ë 19, 2006 11:59 am ¤å³¹¥DÃD: |
|
|
þ¥»®Ñ»¡ªº,§A¥h§ä¥L"²z½×"³o¥y¸Üªº·N¸q¤£´N¦¨¤F,§Æ±æ§A¤£·|ı±o²Ö,¤SµL²á
Y¬O¥u¬On¬Ý¶¶§ÇÃö«Y,³q±`¦³±Æ§ÇÁä
¨º#3,#4¤]¥i¦¨¬°¬YÓÄæ¦ì¨Ó°µ
·íinsert ¬Y¤@¦C¶i¨Ó«á,¦A«±Æ¤]¥i¥H
°O±osort ¦n¹³·|«±Æªº¼Ë¤l,¦Û±q¦³select ......order by ¤§«á
§Ú´N©ñ±ó¥¦¤F
recno()¤£¥h°Ê¥¦,¦n¹³·|¦¨¬°¸ê®Æ¶i¤Jtable ªº¥ý«á¶¶§Ç
è¸Õ¤F¤@¤U,¬O¨Æ¹êC
±q¨Ó³£¨S¦³·Q¹L,¦³¤H·|·d³oºØ¸¾÷»¡ |
|
¦^³»ºÝ |
|
 |
jeff2004
µù¥U®É¶¡: 2005-10-30 ¤å³¹: 27
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤G¤ë 19, 2006 1:36 pm ¤å³¹¥DÃD: |
|
|
¨º»ò¨ì©³«ç¼Ë¤~¯à¨Ï¥Îxbase«ü¥O¦b2Ó°O¿ý¤§¶¡·s¼W¤@Ó°O¿ý©O? |
|
¦^³»ºÝ |
|
 |
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤G¤ë 19, 2006 7:30 pm ¤å³¹¥DÃD: |
|
|
jeff2004 ¼g¨ì: | ¨º»ò¨ì©³«ç¼Ë¤~¯à¨Ï¥Îxbase«ü¥O¦b2Ó°O¿ý¤§¶¡·s¼W¤@Ó°O¿ý©O? |
Ó¤H·Qªk°Õ,°²¸Ëªº
˨ìarray ùØ,¥i¯à¦A°Ñ·Óºtºâªkùتºinsert ¤@Ónode
¦Azap ©Mappend ¦^table
©Î¬O¥æ´«°O¿ý,¦A«·s±Æ§Ç
¥u¬O.......
¬°¦ón¦p¦¹¤j¶O¶g³¹¥h³B²z¤@Ó²ö¶·¦³ªº°ÝÃD
Y»¡¬O°V½m¸£µ¬´N»¡ªº¹L¥h¤F
©Ò¥H,§Úªºµª®×¬O¨S¦³!,Ó¤H¬Ýªk |
|
¦^³»ºÝ |
|
 |
garfield Site Admin

µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2160
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤G¤ë 19, 2006 11:05 pm ¤å³¹¥DÃD: |
|
|
dos ª©ªº help ³o¼Ë¼gªº.
If the file is indexed, INSERT works like APPEND.
* Caution *
INSERT isn't recommended for use with large tables/.DBFs
because an insertion near the front of the table/.DBF
forces rewriting of nearly every record. This can take
a very long time. Use INSERT - SQL instead.
BEFORE
Issuing INSERT BEFORE inserts a new record into the
current table/.DBF immediately before the current
record. The record is then displayed for editing. Data
can be entered only into the new record.
BLANK
Issuing INSERT BLANK inserts a blank record immediately
after the current record. An editing window isn't
displayed.
****
¥h´ú¸Õªºµ²ªG¬O:
¥un¦³¯Á¤Þ, ´Nºâ¬O set order to 0
¤]µLªkinsert , ¥u·|¹³ append. _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 20, 2006 9:21 am ¤å³¹¥DÃD: |
|
|
¨ä¹êvfp®Ú¥»¨S¦³©Ò¿×"insert",³£¬O"append". ^_^|||
insert ¥Ø«e»Pappend§@¥Î¤@¼Ë.
¥u¬O¬°¤F»yªk¬Û®e©Ê¦s¦b.
¦ý¬O¦b foxpro for windows v2.6ª©,
ªº½T¬O·|"´¡¤J"¤@µ§°O¿ý,
¦ý¬O«o·|³y¦¨°O¿ýªº·h²¾,
¹ï©ó¤w¦³¤j¶q¸ê®Æªºtable,
³o¬O¤@¶µ¨aÃø.
¸ê®Æ®wºÞ²z¨Ã¤£±j½Õ¸ê®Æ°O¿ý¦s©ñªº"¹ê»Ú(phycsical)"¶¶§Ç,
¦Ó¬O§Q¥Î"¯Á¤Þ(index)"¨ÓºÞ²z¥L̪º"ÅÞ¿è(logical )"¶¶§Ç,
§Ú·Q¼Ó¥DÀ³¸Ó±µÄ²¸ê®Æ®wºÞ²z¤£¤[,
¥i¥Hªº¸Ü,¥i¥H¥h§ä¤@¨Ç¸ê®Æ®wºÞ²z·§½×¤§Ãþªº®ÑÄy·í¸É¥R±Ð§÷.
¦pªG§A³o»ò¦b·N¶¶§Çªº¸Ü,
¤@¯ëªº°µªk¬O
1.¥ý¤£ºÞ¶¶§Çª½±µappend/insert¸ê®Æ.
2.¥[¤J¯Á¤Þ,§â¸ê®Æ¨Ì§Anªº¶¶§Ç±Æ¦n.
3.§Q¥Î copy to xxxx.dbf ¥t¦sÀÉ®×.
4.§R°£ì¥ýÀɮפΧó§ïèè¥t¦sªºÀɦW.
³o¥i¯à´N¬Ofox pro for windwos ¤§«eªº°µª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¦£ |
|
¦^³»ºÝ |
|
 |
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 20, 2006 12:37 pm ¤å³¹¥DÃD: |
|
|
[1.¥ý¤£ºÞ¶¶§Çª½±µappend/insert¸ê®Æ.
2.¥[¤J¯Á¤Þ,§â¸ê®Æ¨Ì§Anªº¶¶§Ç±Æ¦n.
3.§Q¥Î copy to xxxx.dbf ¥t¦sÀÉ®×.
4.§R°£ì¥ýÀɮפΧó§ïèè¥t¦sªºÀɦW. ]
§Ú°O±ocobol ªº®ÑÁ¿¨ìsort ®É,´N¬O³o»ò°µªº
§Ú¬O¥ý¾Çcobol ¦A¾Çdbase
dbase ªºsort «Ü¦n¥Î,¨º´N¤£¥²¥h²z·|cobol ¤F,¦³¥¦ªº·§©À´N¦æ¤F
¦Ó¬JµMsql ¤¤ªºselect ......order by «Ü¦n¥Î
¨º§ÚÁÙ¥h²z·|dbase ªºsort ©R¥O¶Ü?
§Úªº·Qªk¬O³o¼Ë°Õ |
|
¦^³»ºÝ |
|
 |
jeff2004
µù¥U®É¶¡: 2005-10-30 ¤å³¹: 27
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 20, 2006 5:42 pm ¤å³¹¥DÃD: |
|
|
µo²{¤F°ÝÃD©Ò¦bì¨Ó¦b©óindex¯Á¤Þ,¨ºÓªí¥»¨³]©w¤F¯Á¤Þ,
©Ò¥H¥Îinsertªº®ÉÔ,¤£ºÞ·í®É«ü°w¦bþ,«ü°w³£·|¦Û°Ê¸õ¨ì³Ì§À,©Ò¥H·|¦b³Ì«á¥[¤J·s°O¿ý,¨ú®ø¤F¯Á¤Þ¤§«á,«K¯à¦p±`ªº¦b2Ó°O¿ý¤§¶¡¥[¤J¤@·s°O¿ý
²{¦b¤S¥X¤F¤@Ó°ÝÃD,´N¬O¯à¤£¯à¦b¤£¨ú®ø¯Á¤Þªºª¬ºA¤U¦b2Ó°O¿ý¤§¶¡¥[¤J¤@·s°O¿ý? |
|
¦^³»ºÝ |
|
 |
¤p¿à
µù¥U®É¶¡: 2004-12-27 ¤å³¹: 476
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 20, 2006 6:23 pm ¤å³¹¥DÃD: |
|
|
jeff2004 ¼g¨ì: |
¨ú®ø¤F¯Á¤Þ¤§«á,«K¯à¦p±`ªº¦b2Ó°O¿ý¤§¶¡¥[¤J¤@·s°O¿ý
°O¿ý? |
¯uªº ? °²ªº ?
¨º´Nªí¥Ü«e´X¼Óªº¥ý¶iÌ; ³£¬OÀH«K»¡»¡ªº®@....
......¤£¹L§ÚÁÙ¬OÃø¥H¬Û«H |
|
¦^³»ºÝ |
|
 |
garfield Site Admin

µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2160
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤G¤ë 20, 2006 6:57 pm ¤å³¹¥DÃD: |
|
|
§Ú¦³°µ¹ê´ú³ø§i,
¬O¦³¤HÀH«K¬Ý¬Ý,
¤£¬O¦³¤HÀH«K»¡»¡ªº®@.. _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
 |
¤p¿à
µù¥U®É¶¡: 2004-12-27 ¤å³¹: 476
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 21, 2006 7:59 am ¤å³¹¥DÃD: |
|
|
garfield ¼g¨ì: | §Ú¦³°µ¹ê´ú³ø§i,
¬O¦³¤HÀH«K¬Ý¬Ý,
¤£¬O¦³¤HÀH«K»¡»¡ªº®@.. |
ÀH«K¬Ý¬Ýªº¤H ? ¸Ó¤£·|¬O»¡§Ú§a ?
........§¹¤F ! ¤S¬O¹ï¸¹¤J®y  |
|
¦^³»ºÝ |
|
 |
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4249 ¨Ó¦Û: Taipei,Taiwan
²Ä 12 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 21, 2006 9:56 am ¤å³¹¥DÃD: |
|
|
¦n°Õ,¦n°Õ,¬O§Ú°Õ.
§Ú¤]§Ñ¤F¨ú®øINDEX¨Ó§@¹êÅç. XD _________________ ¦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¦£ |
|
¦^³»ºÝ |
|
 |
garfield Site Admin

µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2160
²Ä 13 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 21, 2006 9:57 am ¤å³¹¥DÃD: |
|
|
function »~·|
para ¤å³¹
if ¤å³¹=ÀH«K¼g¼g or ¤å³¹=¤åµ§¤Ó®t or ¤å³¹=^¤å¦r¤Ó¦h¬Ý¤£À´ or ¤å³¹=¦b¬Ý¤å³¹®É¸ò§O¤H²á¤Ñ¥´§¾ or ¤å³¹=©ç½æºô¯¸´£¿ô§Aªº¥X»ù³Q¶W¶V¤F
µ²ªG= ÀH«K¬Ý¬Ý
else
µ²ªG= ¦³¬Ý¨S¦³À´
endif
return µ²ªG _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
 |
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 14 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 21, 2006 10:23 am ¤å³¹¥DÃD: |
|
|
§Ú¥Îªº¬Otable ¨S¦³index
¦Ó¥B¬O«Ü²³æªºtable |
|
¦^³»ºÝ |
|
 |
jeff2004
µù¥U®É¶¡: 2005-10-30 ¤å³¹: 27
²Ä 15 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 22, 2006 6:42 pm ¤å³¹¥DÃD: |
|
|
²³æ¤@ÂI¦a°Ý,¦b¦³¯Á¤Þªº±¡ªp¤U¯à¦b2Ó°O¿ý¤¤´¡¤J¤@·s°O¿ý¶Ü? |
|
¦^³»ºÝ |
|
 |
|