µoªí¤H |
¤º®e |
¥DÃD: ±N¬d¸ßªº¸ê®ÆÂà¥X¨ìEXCEL °ÊºAÄæ¦ì¦WºÙ |
perry
¦^ÂÐ: 10
Æ[¬Ý: 14867
|
ª©±: 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
Æ[¬Ý: 4497
|
ª©±: 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
Æ[¬Ý: 9803
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤Q¤@¤ë 17, 2020 9:49 pm ¥DÃD: Á{®Éªí¦æ§R°£? |
±N¸ê®Æ¿é¥X¦Ü Excel ¥i»´ÃP逹¨ì±znªº§R°£¤Î¦Lªí»Ý¨D!! |
¥DÃD: Á{®Éªí¦æ§R°£? |
perry
¦^ÂÐ: 14
Æ[¬Ý: 9803
|
ª©±: 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
Æ[¬Ý: 3754
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤»¤ë 03, 2020 10:47 am ¥DÃD: COPY FILE ¤§¤j¤p¼g°ÝÃD |
¥Î run or ! °õ¦æ copy ¥i§JªA.
µwn¥Î 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
Æ[¬Ý: 4710
|
ª©±: 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
Æ[¬Ý: 11545
|
ª©±: 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
Æ[¬Ý: 10823
|
ª©±: 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
Æ[¬Ý: 4606
|
ª©±: 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
Æ[¬Ý: 50641
|
ª©±: 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
Æ[¬Ý: 19838
|
ª©±: 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
Æ[¬Ý: 42566
|
ª©±: 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
Æ[¬Ý: 25503
|
ª©±: 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
Æ[¬Ý: 12589
|
ª©±: 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
Æ[¬Ý: 8021
|
ª©±: 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Äæ±²¦Üµøµ¡³Ì¥ª¤è |
|