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

¦³ 203 µ§¸ê®Æ²Å¦X±z·j´Mªº±ø¥ó
VFP ·R¥ÎªÌªÀ°Ï ­º­¶
µoªí¤H ¤º®e
  ¥DÃD: ±N¬d¸ßªº¸ê®ÆÂà¥X¨ìEXCEL °ÊºAÄæ¦ì¦WºÙ
perry

¦^ÂÐ: 10
Æ[¬Ý: 13988

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤­ ¤T¤ë 19, 2021 6:03 pm   ¥DÃD: ±N¬d¸ßªº¸ê®ÆÂà¥X¨ìEXCEL °ÊºAÄæ¦ì¦WºÙ
¸Õ¸Õ±N
MONEY1 AS &T1.,;
MONEY2 AS &T2.,;
MONEY3 AS &T3.,;
MONEY4 AS &T4.,;
MONEY5 AS &T5.,;
MONEY6 AS &T6.,;
MONEY7 AS &T7.,;
§ï¦¨
MONEY1 AS &T1 ,;
MONEY2 AS ...
  ¥DÃD: SEEK ¨Ï¥Î SET ORDE XXX DESC°ÝÃD
perry

¦^ÂÐ: 2
Æ[¬Ý: 4158

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤­ ¤Q¤G¤ë 18, 2020 12:38 am   ¥DÃD: SEEK ¨Ï¥Î SET ORDE XXX DESC°ÝÃD
seek 'A1 ' ´M§äªø«× 3 byte
À³¤£¥i¯àÅܦ¨ seek 'A1' ´M§äªø«× 2 byte
¥i¯à±z¦³³B²z±¼ªÅ¥Õ
¦p allt('A1 ') or rtri('A1 ') ¤~·|Åܦ¨ seek 'A1'
  ¥DÃD: Á{®Éªí¦æ§R°£?
perry

¦^ÂÐ: 14
Æ[¬Ý: 8730

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤Q¤@¤ë 17, 2020 9:49 pm   ¥DÃD: Á{®Éªí¦æ§R°£?
±N¸ê®Æ¿é¥X¦Ü Excel ¥i»´ÃP逹¨ì±z­nªº§R°£¤Î¦Lªí»Ý¨D!!
  ¥DÃD: Á{®Éªí¦æ§R°£?
perry

¦^ÂÐ: 14
Æ[¬Ý: 8730

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤» ¤Q¤@¤ë 07, 2020 3:28 am   ¥DÃD: Á{®Éªí¦æ§R°£?
§Q¥Î 2¦¸ SQL
sele 0
sele sum(iif(empt(f1),0,1)) as f1,sum(iif(empt(f2),0,1)) as f2,;
sum(iif(empt(f3),0,1)) as f3,sum(iif(empt(f4),0,1)) as f4 ;
from test1 into curs aa_1
go top
priv i,j ...
  ¥DÃD: COPY FILE ¤§¤j¤p¼g°ÝÃD
perry

¦^ÂÐ: 2
Æ[¬Ý: 3417

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤T ¤»¤ë 03, 2020 10:47 am   ¥DÃD: COPY FILE ¤§¤j¤p¼g°ÝÃD
¥Î run or ! °õ¦æ copy ¥i§JªA.

µw­n¥Î vfp copy «ü¥O¨Sªk¹F¨ì®ÄªG!!

³o­Ó°ÝÃD¤j¤j¦b¤T¦~«e´¿´£¹L,·j´M ¤j¤p¼g ¥i±o@@
  ¥DÃD: LQ-690 ¦C¦L¼eªº°ÝÃD
perry

¦^ÂÐ: 2
Æ[¬Ý: 4238

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤­ ¤@¤ë 03, 2020 11:36 pm   ¥DÃD: LQ-690 ¦C¦L¼eªº°ÝÃD
¥H«eLQ¦Lªí¾÷¦C¦L½d³ò¥i¥H¿ï³Ì¤j.
¦ýLQ-690¹w³]¬O¼Ð·Ç(¤ñ¸ûµu¯¶)!!
¦n¹³¦Û©w®æ¦¡ªº¤~·|¥X°ÝÃD.
  ¥DÃD: Ãö©ó³øªíÀɪºExprÄæ¦ì¤º®e
perry

¦^ÂÐ: 9
Æ[¬Ý: 10812

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤T ¤­¤ë 01, 2019 2:40 pm   ¥DÃD: Ãö©ó³øªíÀɪºExprÄæ¦ì¤º®e
½Ð°Ý¤W¹Ï¿ï¨ú¦Lªí¾÷¤§«á<½T©w>¤Î<¨ú®ø>ªº­È­n¦p¦ó¨ú±o?
¸Õ¸Õ!!
?set('printer',3)
Default Visual FoxPro printer name
(specified in the Visual FoxPro Print or Print Setup dialog boxes)
  ¥DÃD: µ{¦¡¤Ó¤j
perry

¦^ÂÐ: 14
Æ[¬Ý: 9721

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤­ ¥|¤ë 26, 2019 5:18 pm   ¥DÃD: µ{¦¡¤Ó¤j
¦³¥i¯à³æ¤@prg,scx...¤Ó¤j³y¦¨!!
§Q¥Î do prg ¤è¦¡±N¨äÁY¤p.
³Ì«á­×§ï³y¦¨°ÝÃD event or prg (¶W¹L100kb)
¨Ò¦p:
proc test
do case
case ...
do testsub1
case ...
do testsub2
endc
do test ...
  ¥DÃD: ¦p¦óÃö³¬form¥k¤W¨¤ªº³Ì¤j¤Æ³Ì¤p¤Æ»PÃö³¬
perry

¦^ÂÐ: 3
Æ[¬Ý: 4254

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤­ ¥|¤ë 12, 2019 7:27 am   ¥DÃD: ¦p¦óÃö³¬form¥k¤W¨¤ªº³Ì¤j¤Æ³Ì¤p¤Æ»PÃö³¬
thisform.controlbox=.f.
  ¥DÃD: ¦h¤Hª©¦p¦ó±±¨îªí³æ¯àÁ䦳¤H¨Ï¥Î¤¤¨ä¥L¤H¤£¯à¨Ï¥Î,½Ð±Ð¦U¦ì¥ý¶i
perry

¦^ÂÐ: 42
Æ[¬Ý: 43988

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤T ¤G¤ë 06, 2019 12:14 pm   ¥DÃD: ¦h¤Hª©¦p¦ó±±¨îªí³æ¯àÁ䦳¤H¨Ï¥Î¤¤¨ä¥L¤H¤£¯à¨Ï¥Î,½Ð±Ð¦U¦ì¥ý¶i
¸Õ¸Õ!!
«Ø¤@­Ó¦@¥Î¸ê®Æ§¨

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¨Ï¥Î¤¤
e ...
  ¥DÃD: ¨â­Ó PROJECT ¥Î¦P¼Ëªºµ{¦¡½X¼g Excel ³øªíµe®Ø½u¡A¦ý°õ¦æ®É¤@­Óok¤@­Ó¿ù»~
perry

¦^ÂÐ: 3
Æ[¬Ý: 19442

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤» ¤@¤ë 26, 2019 2:42 pm   ¥DÃD: ¨â­Ó PROJECT ¥Î¦P¼Ëªºµ{¦¡½X¼g Excel ³øªíµe®Ø½u¡A¦ý°õ¦æ®É¤@­Óok¤@­Ó¿ù»~
¸Õ¸Õ!!
oExcel.Range("A1:A10").Borders.LineStyle=1 &&ª½±µ³æ½u¤è®Ø

borders(N)
7 ¥ªª½½u
8 ¤W¾î½u
9 ¤U¾î½u
10 ¥kª½½u

xlEdgeLeft ÅܼƬOExcel VBA©Ò©w¸q,VFP½Õ¥Î¤£¨ì(¤£»{ÃÑ@@)
  ¥DÃD: ¦p¦ó±N¦h¤À­¶ªºXLSX¤å¥óÂରDBF®æ¦¡
perry

¦^ÂÐ: 8
Æ[¬Ý: 41851

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤T ¤Q¤ë 17, 2018 8:40 am   ¥DÃD: ¦p¦ó±N¦h¤À­¶ªºXLSX¤å¥óÂରDBF®æ¦¡
j=xlapp.workbooks(1).sheets.count
for i=1 to j
j1=xlapp.workbooks(1).sheets(i).usedrange.rows.count &&¦U¸Õºâªí¨Ï¥Î¦C¼Æ
for i1=1 to j1
. §PÂ_ª½Äæ­È,¦³«h·s¼W¦Üdbf
.
...
  ¥DÃD: VFP¦p¦ó¤@¦¸¦C¦L¦h¥÷Excel¤å¥ó
perry

¦^ÂÐ: 2
Æ[¬Ý: 25061

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤C¤ë 03, 2018 4:41 am   ¥DÃD: VFP¦p¦ó¤@¦¸¦C¦L¦h¥÷Excel¤å¥ó
expression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName)
expression ¥²¿ï¡C¸Ó¹Bºâ¦¡¶Ç¦^ [®M¥Î©ó] ²M³æ¤¤ªºª«¥ó¡C

From ¿ï¾Ü©Êªº Variant¡C¦C¦Lªº°_©l­¶¸ ...
  ¥DÃD: XCOPY¹Lµ{¤p°ÝÃD
perry

¦^ÂÐ: 6
Æ[¬Ý: 10741

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤Q¤G¤ë 05, 2017 9:24 am   ¥DÃD: XCOPY¹Lµ{¤p°ÝÃD
RUN or ! or winscript.shell.run or ShellExecute
°ò¥»¤W¬O°õ¦æ¥~³¡µ{§Çªº°Ê§@,
¦bVFP¤¤¥u¬O¤@¹D«ü¥O,
§¹¦¨»P§_©M¤£¬O VFP ©Ò¯à´x±±!!
  ¥DÃD: ½Ð°Ý¦p¦ó±NEXCEL¿ï¨úÄæ¦ì©ñ¤jÅã¥Ü¦bµøµ¡¤¤? (OK)
perry

¦^ÂÐ: 2
Æ[¬Ý: 7291

µoªíª©­±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤Q¤@¤ë 14, 2017 11:28 am   ¥DÃD: ½Ð°Ý¦p¦ó±NEXCEL¿ï¨úÄæ¦ì©ñ¤jÅã¥Ü¦bµøµ¡¤¤? (OK)
lXLApp.ActiveWindow.ScrollRwo=59
** ±N²Ä59¦C±²¦Üµøµ¡³Ì¤W¤è
lXLApp.ActiveWindow.ScrollColumn=18
** ±N²Ä18Äæ±²¦Üµøµ¡³Ì¥ª¤è
 
²Ä1­¶(¦@14­¶) «e©¹­¶­± 1, 2, 3 ... 12, 13, 14  ¤U¤@­¶
©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
«e©¹:  


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@