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



ϵͳȨ
춫ƽ
ժҪϵͳж༶ƼȨƵʵԭʵϵͳȨݱʾͻܣVFP 5.0֧ԺSQL˿˼롣
ؼʣݿ⡡ϢϵͳȨ
1ӴϵͳŶְܲŵĶҵҵҪӦϢʩЩϵͳڷֲʽݿ⼰缯ɻʵֵġΪҵԱûڲͬվϽϵͳԲϵͳȨƷʽʹְͬܲŻܽԼзȨϵͳܣڱ֤ϵͳȫΪҪ
ûʹԼĿ¼ϵͳûȨޣֹܣֹܡͬûӦͬ𣬿ɷΪϵͳйʹȨޣ޸˿Ȩȫܡ弶ɾԼ޸Ĺܣɱûܡһ㼶бĹܣЩвԼ޸Ĺܼɱûܡ
1
VFP 5.0ɻΪVFP 5.0ǰ̨ԣðƽûйʵ˼룬˼ֽ֧WINDOWS NT4.0£SQL SERVER 6.5ݿϵͳ̨ݿϵͳҲֵ֧µϵͳ
VFP 5.0˵УһѡӾ䡰SKIP FOR<߼ʽ>߼ʽΪʱò˵㱻ԡ˵ԣĻϼӦ˵ܱѡ
ڼɿ(IDE)Ĳ˵УOPTIONֵĶԻSKIP FORѡ߼ʽ߼ʽŲ˵ӦѡЧԡ
Ӿ书ܣÿһ˵d(i)Ӧ1߼contrx(i)û¼ϵͳûʱ㽫ûĹӦĲ˵е߼contrxóɡ١contrxóɡ桱
ҪʵƣҪϢ
1.FfpϵͳԱFF㣺
F={ff1Ա1ְܲţfΨһӵпP}
ͼ1ΪFĹϵ*fFеĹؼ֡

ͼ1FĹϵ
2.frfĳԱԱrϵͳԱְܲŸ˿frfr㣺
f={rrfĳԱԱ}
ͼ2ΪfrĹϵ*f*rfrеĸϹؼ֡

ͼ2frĹϵ
3.fdfйdϵͳԱfdfd㣺
fd={dd(ϵͳȫ)fd}
ͼ3ΪfdĹϵ*f*dfdеĸϹؼ֡

ͼ3fdĹϵ
4.fcسp,pΨһڣҲɿͼ4ʾĹϵ

ͼ4fcĹϵ
ϹϵҲʵϵģͼ(E-Rͼ)ͼ5

ͼ5ʵϵģͼ
ϵͳӦðϵͳȫйصĹܣ
1.Լd1ʾ޸Ŀ
2.Լûd2ʾȫԱ޸ĻɾԱ
3.ȫd3ʾȫ()޸Ļɾ塣
4.һûd4ʾȫгԱɾġ
5.Ȩd5һָɽ빦ܡ
2˼
P()һûR¼Ӧûйȷӳsubp
p=Pйܣ
select fd.d from fd,F where F.p=P and F.f=fd.f and(p not in(select p from fc)and not inlist(d,`d3',`d4',d5')or p in (select p from fc))into cursor temfoun1 varfoun1=tally
пPûvarfoun1ܣЩݴڴļtemfounlС
r=Rйܣ
dimention x(2)
select distinct fr.f from fr where fr.r=R into carry x
select fd.d from fd,F where F.f=x(1)and F.f=fd.f and notinlist(d,`d1',`d2',`d3',`d4',`d5')intocursor temfoun2
varfoun2=tally
пRûvarfoun2ܣЩݴڴļtemfoun2С
Ϊʵֲ˵ƣϵͳпɽSYSSYSнԪcϵͳdӦϵͼ6

ͼ6ԪcϵͳdĶӦϵ
ϵͳܹΪMAXFƲ˵£
do subp
for i=1 to MAXF
contrx(i)=.t.
endfor
if varfoun1>0
select c from sys where d in(select d from temfoun1)into cursor temfoun3
else
select c from sys where d in(select d from temfoun2)into cursor temfoun3
endif
scan
vartem=c+=.f.'
&vartem
endscan
3ܱǿ
ܱǿȣȡϵͳпıǿȡ˵֪༶ȫڱСΪ߿ıǿȣԽFиԪpֵfrиԪrֵĴţڿƲ˵УתΪڴʱб棬ȻƳ򡣹ļı任⣬Ĳϸۡ
ߵλ人ͨƼѧϵ(430063)
ο
1Microsoft.SQL SERVER 6.5Աָ.ѧ磬֣1997
2ͨ.Visual FoxPro 3.0ʵ.ѧԷ磬1997
(ոڣ1998-06-25)
