΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
1999 18 1 Vol.18 No.1 1999



Visual FoxProֵֶĴӦ
־졡
ժҪVisual FoxProƴֵֶķʵʳΪֵֶϢɼӦ͡
ؼʣֵ䡡Visual FoxPro򿪷
ƴӦĿʹõĸݿVisual FoxProĿһҪͨñ񣬲ÿÿֶεԷֱһһáʵʿУͬһӦĿݿĲͬгֶͬΡЩֶͬεͬԶظ룬Ӱ칤ЧʣҲһ¡ˣ߳ϣҵ1ַɿݿṹƷ
1ֵ
ĽֵܵǳɹӦóһҪʵݿİȫԡԡһԡɻָԡЧԡ޸ԼԵҪֶ֮һֵΪЩܸܺҺܺʱĳ򿪷ṩı׼Ϣʹݡһ棬ҲΪĿĵṩ˷㡣
Visual FoxProֵ2ַVisual FoxProṩݿʹԼֵ䡣
ֵҪĿľǴ洢1ֶεϢԱؽòVisual FoxProݿУ洢˸ݿиĶԼǵԣDatabase(ݿ)Table()Index()Field(ֶ)View(ͼ)ȡд洢ֶУDefault value(ȱʡֵ)Format(ʽ)Input mask()Caption()Comment(ע)Rules()Triggers()Display class(ʾ)ȡǣݿв洢ֶ͡ССλԣЩϢֻDBFıͷСDBFļƻ޷ȷϢˣЩҪֵΪԶֶϢ
Visual FoxProݿ1ɱΪݿԭнṹĩβµֶΡıݿ8ԭֶεĻṹܱ޸ģΪԭֶεκθĶӰ쵽ݿԣ޷κݿ฽ӵҪ洢ҲȡݿһЩ⣬ݿ֮ⴴԼֵ䡣
Ҫʹ1ֵԳ򿪷ãṹͨ1ֵӦðӦóֵ䡢ݿֵ䡢ֵ䡢ֵֶ䡢ϢֵԼ洢ֵϵĹϵֵȶֵ䡣
ǰֵҪĿľǴ洢ֶεϢ潫ؽֵֶĽӦáֵ߿ɸƵķԼԼҪдӦá
2ֵֶĴ
2.1ֵֶṹ
ֵֶжӦĿһݿбʹõȫֶΡĿΪȷֶͬξͬƼԡʹ1ֶαʹãҲֻ1Σȷֶζǹ淶׼ġ
ݿеֶΪݣṹDBFֶƵֵֶ(DICT.DBF)ṹ£
ֶ˵ֶ͡
ֶơFIELDNAMEַ͡10
ֶ͡FIELDTYPEַ͡1
ֶγȡFIELDLEN ֵ͡3
СλFIELDDEC ֵ͡2
ֵFIELDNULL߼͡1
תFIELDNOCP߼͡1
ֶЧFIELDRULEע͡10
ֶЧϢFIELDERR ע͡10
ֶĬֵFIELDDEFAע͡10
ЧTABLERULEע͡10
ЧϢTABLEERR ע͡10
ֶα⡡FIELDCAPTַ͡30
ֶע͡FIELDCOMMע͡10
ֶθʽFIELDFORMַ͡30
ֶ롡FIELDINPUַ͡30
ֶʾ⡡FIELDLIB   ַ͡30
ֶʾࡡFIELDCLASַ͡30
ñ4ֶΪVisual FoxPro 5.0汾ӵݿֶԣVisual FoxPro 3.0汾ݿûЩԡʵʿУ߿ɲֵṹʹõVisual FoxPro汾ŽȡᣬҲɸݿҪԼֶ͡
2.2ֵֶϢɼ
ֵֶо߱ƵӦõĻΪ1ɱ񣬿߿ԴͨɱһӦĳֵֶ䣬Ӧ롢޸ġѯԱӦڿڽֵֶ䣬Ӧó򿪷ݡѾƵݿṩĳѡݿɼϢԶӵֵֶС
*************************
*MKDICT.PRG
*ݿֵֶ(DICT)
*************************
LOCAL lnOldArea,aTableProp(10,11),cDBName
LOCAL cTableName,cFieldName,cFieldCapt
LOCAL cFieldComm,cFieldForm,cFieldInpu
lnOldArea=select()
CLOSE DATABASE
cDBName=GETFILE(DBC,`ݿ')
IF EMPTY(cDBName)
CANCEL
ENDIF
*ɴݿиʱ
select 0
CREA TABLE TEMPTABL(TABLENAME C(8))
select 0
USE DICT
SET ORDER TO FIELD-NAME
SELECT 0
USE &cDBName
SET ORDER TO Objectname
SCAN FOR objecttype=`Table'
cTableName=TRIM(ObjectNAME)
SELECT TEMPTABL
APPEN BLANK
REPL TABLENAME WITH UPPER(cTableName)
ENDSCAN
USE
*ɼֶϢֵֶ
OPEN DATABASE &cDBName
SELECT TEMPTABL
SCAN
cTableName=TRIM(TABLENAME)
IF USED(cTableName)
SELECT &cTableName
1USED=.T.
ELSE
SELECT O
USE &cTableName
1USED=.F.
ENDIF
aTableProp=.F.
=AFIELDS(aTableProp)
nFieldCount=FCOUNT()
FORnFN=1 to nFieldCount
SELECT &cTableName
cFieldName=aTableProp(nFN,1)+
SELECT DICT
SEEK(cFieldName)
IF.NOT.FOUND()
cFieldCaptTRIM(DBGETPROP(cTableName+.+cFieldName,;`FIELD',`CAPTION'))
cFieldComm=TRIM(DBGETPROP(cTableName+.'+cFieldName,;
`FIELD',`COMMENT'))
cFieldForm=TRIM(DBGETPROP(cTableName+.+cFieldName,
`FIELD',`FORMAT'))
cFieldInpu=TRIM(DBGETPROP(cTableName+.'+cFieldName,;`FIELD',`INPUTMASK'))
SELECT DICT
APPEND BLANK
REPL FIELDNAME WITH aTableProp(nFN,1),;
FIELDType WITH aTableProp(nFN,2),;
FieldLen WITH aTableProp(nFN,3),;
FIELDDec WITH aTableProp(nFN,4),;
FIELDNull WITH aTableProp(nFN,5),;
FieldNocp WITH aTableProp(nFN,6),;
FIELDRule WITH aTableProp(nFN,7),;
FieldErr WITH aTableProp(nFN,8),;
FieldDefa WITH aTableProp(nFN,9),;
TABLErule WITH aTableProp(nFN,10),;
TABLEERR WITH aTableProp(nFN,11),;
FieldCapt WITH cFieldCapt,;
FIELDComm WITH cFieldComm,;
FIELDForm WITH cFieldForm,;
FIELDInpu WITH cFieldInpu
ENDIF
ENDFOR
SELECT (cTableName)
IF NOT 1USED
USE
ENDIF
ENDSCAN
SELE TEMPTABL
USE
DELE FILE TEMPTABL.DBF
=select(lnOldArea)
***********************
*MKDICT.PRGβ
***********************
3ֵֶӦ
Ƶֵֶ䣬ɶݿ봴ʵֶѡֶԵԶáȴﵽ˸Чֱֶ֤Եı׼
*************************
*SETPROP.PRG
*ֵֶݿֶ
*************************
local lnOldArea,lUSED,cTableName,cFieldtype
lnOldArea=select()
cTableName=GETFILE(`DBF',`ݿ')
cTableName=SUBSTR(cTableName,
RAT(`',cTableName)+1)
cTableName=SUBSTR(cTableName,1,
AT(.'cTableName)-1)
IF EMPTY(cTableName)
CANCEL
ENDIF
If USED(dictl)
SELECT DICT1
ELSE
SELECT 0
USE dict1
ENDIF
SET ORDER TO FIELDNAME
IF USED(cTableName)
SELECT &cTableName
1USED=.T.
ELSE
SELECT 0
USE &cTableName
1USED=.F.
ENDIF
nFieldCount=FCOUNT()
FOR nFN=1 to nFieldCount
SELECT &cTableName
cFieldName=FIELD(nFN)+
cFieldCaption=TRIM(DBGETPROP(cTableName+`.'+;cFieldName,`FIELD',`CAPTION'))
SELECT DICT1
SEEK(cFieldName)
If FOUND()
cFieldCaption=TRIM(FieldCapt)
cFieldComment=TRIM(Fieldcomm)
cFieldType=Fieldtype
nFieldLen=FieldLen
nFieldDec=FieldDec
cFieldDefa=FieldDefa
cFieldRule=TRIM(FieldRule)
cFieldErr=TRIM(fielderr)
cFieldInpu=TRIM(FieldInpu)
cFieldForm=TRIM(FieldForm)
?DBSETPROP(cTableName+.'+cFieldName,;
FIELD',CAPTION',cFieldCaption)
?DBSETPROP(cTableName+.'+cFieldName,;
`FIELD',`COMMENT',cFieldComment)
?DBSETPROP(cTableName+.+cFieldName,;
`FIELD',`FORMAT',cFieldForm)
?DBSETPROP(cTableName+`.'+cFieldName,;
`FIELD',`INPUTMASK',cFieldInpu)
IF NOT EMPTY(cFieldDefa)
 ALTER TABLE(cTableName);
ALTER COLUMN &cFieldName.;
SET DEFAULT EVALUATE(cFieldDefa)
ENDIF
 ALTER TABLE(cTableName);
ALTER COLUMN &cFieldName.;
&cFieldType(nFieldLen,nFieldDec)
ENDIF
ENDFOR
SELECT(cTableName)
IF NOT 1USED
USE
ENDIF
=select(1nOldArea)
**********************
*SETPROP.PRGβ
**********************
Windows 95Windows NTƽ̨£Visual FoxPro 3.05.0汾вͨ
ֵǳɹЧӦó򿪷һҪ档ֻǶ书ܡӦ˳ܣϣ򿪷ߵ㷺á
ߵλ人йʴѧԴѧԺϢϵͳо(430074)
ο
1Antonovicb M.Visual FoxProʹֲ.еҵ磬1997
2.Visual FoxPro 3.0ָ.廪ѧ磬1996
3.ʿԴϢϵͳԭӦ.йʴѧ磬1996
(ոڣ1998-07-01)
