Ӧ
Computer Applications
1999 19 7  Vol.19 No.7 1999



VFP5.0 ໥
ԡ

ժҪĽVisual FoxPro5.0ṩOLEԶActiveXؼȼʵVisual FoxPro ӦDELPHIEXCELWORDVBȽݺͳ໥ϵ
ؼʡVFPDelphiExcelWordVBOLEActiveX

Visual FoxPro5.0(¼VFP)ṩOLEǶ룬ԶDLL̬ӿ⼰ActiveXؼȼΪûֱӵӦóṩ˷㡣VFPûڿԼӦóʱɳWindowsӦVBDelphiExcelWordActiveXؼȣṩǿܡͬʱVFPṩODBCԶûӦҲʹVFPеݣ
˽VFPӦóϵֵܹں͸㹦ܣӿӦóĿٶȺͿ
1VFPOLE
VFPṩOLEɽӦóݿһ󣬷ڱϻеֶͨСVFPǶ뷽ʽӷʽӦóݡǶ뷽ʽӷʽĲͬݵĴ洢ص㡣Ƕ뽫ֱӴ洢У˶;
VFPṩʽOLEͺͷǰ͡áؼеOLEͿؼOLE󣬶OLEؼǰOLE󡣰OLEһеֶͨϵڱֶͨһWordĵһͼƵļȡǰOLEϵڱOLEзActiveXؼһWindows.EXE
ActiveXؼַʽһַʽƱʱֱã岽Ϊ1ӡؼѡOLEڱϣ2ڡ༭ѡInsert Object,ڶԻѡInsert Control3ڡControl TypeбѡҪActiveXؼVFPһ𷢲ActiveXؼ Windows 95ؼϵͳؼȡһַʽʹԶó̬OLE
2VFP.EXEļ
VFPӦóԼıͨOLEؼӦó򡣱DelphiVBȿӦóϵVFPӦóСVFPӦóпͨ뷽ʽ̬.EXEļ
 VFPִ֧ո·ΪVFPصӦóȽصӦóļVFPĿ¼Ӳô뷽ʽDelphiӦóProject1.exe 
Pro1.prg
* VFPDELPHIӦóproject1.exe
* ȴһOLEؼ
* ӦóProject1
Set Talk Off
Clear
frmMyForm=CreateObject(form)&&һ
frmMyForm.Closable=.F.
frmMyForm.AddObject(CmdCommand1,CmdMyCmdBtn)
&&ť
frmMyForm.AddObject(OleObject,Myclass)
&&OLEfrmMyForm.CmdCommand1.Visible=.T. 
&&ʾQUITťfrmMyForm.OleObject.Visible=.T. 
&&ʾOLEؼ
frmMyForm.OleObject.Height=150 
&&OLEؼߴ
frmMyForm.OleObject.Width=200
frmMyForm.Show&&ʾ
frmMyForm.OleObject.DoVerb(0)
&&ִOLE
Read Events&&ʼ¼
Define Class MyClass as OleControl
&&OLEؼ
DocumentFile =c:\vfp\project1.exe
&&ָOLEִļ
Enddefine
Define Class cmdMyCmdBtn as CommandButton
&&ť
Caption=  
&&ťϵı
Cancel=.T. &&ĬQUITť
Left=125 
&&ťĳߴ
Top=210
Height=25
Procedure Click 
&&ֹͣ¼
Clear Events
Enddefine
Return

ô˶γVFPеø.EXEӦóWindowsӦó

3VFPDLLе
DLLDynamic-Link Library̬ӿһչΪ.DLLĿִģ飬а˿ԱӦóDLL̺ԴDLLҪصĴڼ䶯̬ӵĳСDLLеִ󣬿ʱDLLڴDLLʵָӦóԴʡڴռ䡣üWindowsб㷺ӦáVFPDelphiVBC++ȱдDLL̻Windows APIרVFPFLL̡ڵһDLL֮ǰ˽̵ĵЭ飬̵ƣĿԼֵ͡дDLLʱӦñ׼ԼDelphiдDLLʱDLLйӦóọ̣̃Ҫ ExportsҪStdcallԼԱԱдӦóҲܵøDLLе̡
 VFPУⲿDLLеǰӦʹDECLARE--DLLҪõDLLе̡DECLARE--DLLĻʽΪ
DeclarecFunctionTypeFunctionName IN LibraryName
As aliasNameݣcParamType1@ParamName1, 
cParamType2@ParamName2,...
LibraryNameҪõĶ̬ӿ
CFunctionTypeҪõDLLе̵͡
зֵ
ûзֵø
FunctionNameõ
cParamType1@ParamName1βεͼơ
cParamType2@ParamName2βεͼơ
ʹDLLʱӦע⣺
* ΪصDLLȽҪõDLLƵVFPĿ¼Ա֤VFPȷDLL
* DLLеִСд
VFP˳֮ǰصDLLһֱЧҪDLLе̣ʹCLEAR ALL DLLSжDECLARE--DLLⲿ32bitDLLԽʡڴԴ
VFPDLL̵ʵ
3.1VFPDelphiдDLL
ҪõDLLеÿһ̶ӦDECLARE--DLLءVFPеDelphiдMyDLL.DLLеAdd(x,y)
Set Talk Off
Clear
*declareDLLеAdd
Declare integer Add in MyDLL.DLL integer @x,integer @y
a=15
b=10
Wait Window"ڵAdd" Timeout 2
c=Add(a,b)
?c
Wait Window"ͷżصDLL" Timeout 2
Clear All Dlls
Return
3.2VFPWindows API
Win32APIṩڴڵĲӦóӦWin32APIӦóĿͬWindows APIҪWindows USERеGetActiveWindow()úõǰVFP ڵľGetActiveWindow()޲һ
Declare integer GetActiveWindow() in win32api
x= GetActiveWindow()
Messagebox(str(x))
3.3VFPFLLеĺ
VFPеFLLDLLֻVFPʹãFLLרΪVFPڲõĺڵЩʱSET LIBRARY TO <.FLLļ>غڵFLLFLLһؼɵеÿ˵ĲͣDLLеĺͬ
磬VFPFOXTOOLS.FLLеFoxtoolver()Msgbox()Foxtoolver()õFLLļİ汾ţMsgbox()򵯳һʾ
x=Foxtoolver()
If x<>5.0
Msgbox("õFLL汾")
Endif

4ӦóVFP
4.1ͨVFPODBC ݿ
ӦóͨVFPṩODBCVFPݿеݣVFPеݿܣк̨ݹExcelиݷʱʹƵ洢ݿбȴ洢ڹиȫʱʹVisual FoxproODBC򽫹ݿȻȡصݣʾڹУԱһΪWordͨVFPODBC ݿγʼǩ
a. Word˵ѡ񡰹ߡµġʼϲ롰ʼϲ
b. ڡʼϲѡ1. ڵ˵ѡʼǩ ڶԻѡڡ 
c. ڡʼϲ£ѡ2.ȡݡ ڵ˵ѡԴ 
d. ڴѡҪõVFPݿڵĿ¼ѡļΪMS FoxproļѡӦݿTable1.dbf 
e. ʾġȷԴԻУѡFoxpro FilesͨODBC*.dbf ȷť
f. ʾġǩԻУѡϲ ʾָVFPݿеֶѡֶΣ
g. ѡֶκĻַصʼϲ ʱѡ3.ϲ ڡϲԻаϲťͨVFP ODBC ݿȡݣ͵WordĵγӦʼǩ
4.2WordExcelֱӿVFP
VFPΪһͻҲΪһ֧ԶӦóͨVFPApplicationVFPVFPʱͨDDEͨԶԶشһApplication󡣱Excel WordзVFPеTableдΪWordģVisual Basic Application 봴VFPApplication󣬴VFPеݿTable1,еļ¼ճWordĵʵ
Sub Micro1()
Dim oFox as Object
Set oFox=CreateObject("VisualFoxpro.Application")
oFox.DoCmd "use c:\vfp\Table1.dbf"
oFox.DoCmd "Select name,address From Table1 Into temp"
oFox.DataToClip "temp",,3
Word.ActiveDocument.Content.Paste
End Sub
ҪExcelжȡVFPݿݣɶһ޸ģActiveSheet.Paste 
4.3OLE Զ
VFPOLEԶ򣬹ӦóáԶͨഴӦóԱⲿӦó򴴽͹ӦóĶҪʵOLEԶӦĿаOLEPUBLIC࣬һִļ.EXEļһ̬ӿ⣨.DLLļеĴ봴һԶOLEPUBLICࡣ
Define Class Person As Custom OLEPUBLIC
FirstName=Space(20)
LastName=Space(20)
Procedure GetName
Return This.FirstName+" "+This.LastName
Endproc
Enddefine
Excel,WordVB´øԶ
Set oTest=CreateObject("proj1.person")
cName$ =oTest.GetName()
ڱ׼ԶУͻͷͬһУVFP5.0£Ҳ֧ԶԶͨͻ򻹿ԵԶ̷

ߵλԡԣ㽭ƾѧԺϢϵ㽭 310012
ο
1ݡDelphi 3ָ. , 1998
2ݡVisual FoxPro5.0ȫѧϰֲ. ѧ, 1998
3ݡVisual FoxPro5.0߼ָ. , 1998 
ո:1999-01-14
