Ӧ
COMPUTER APPLICATIONS
1999 19 6 Vol.19 No.6 1999



PowerBuilderɹö
񻪡ǽ
ժҪPowerBuilderУòɹö󣬲빫ÿ⣨.pblУƷ߳ĿԺͿάԡƹöһַʵڱ̽֡
ؼʡPowerBuilderö󣬹ÿ

PowerBuilderΪҪݿǰ̨ԣѵõ˹㷺ӦáʵʵĿУرڴ͵ĿĿУĳЩܻദظ֣ѯӡȲÿһﶼ֡ÿһӦΪдһγĻôЩͬеĳƵظģ˳ıд˳άһֿеķǽЩòɹö󣬲빫ÿ⣨.pblУڳʱֱӵصûʹЩ˳ĿԺͳЧʣ˳Ŀάԡ
1˼
öѵͨԵƣʼеĲҪͬʱֱ뱣ֶķǲòݣöֻڲƣʹûùöʱ䴫ĲöƱӦ໥ȻôַƵĹؼڴݲѡ䴦
2ʵ
½Ҫ۵ļöʿԷΪࣺںԶؼӦģǵʹ÷ʽҲͬôĵãؼֱڸбʹá·֮
2.1
2.1.1ѯ
ѯڵǣڻȡ˱ѯݴڵйز󣬼ڣûڱ
йʽʽͬwhereӾ䣩˱ʽԭݴڽйˣԭݴеõûĲѯ
ʹòѯǰ֪ѯڵйزȶһúԻȡݴڵйز
. ݴڲȡ
ȡݴ²еֶͺͱʶ
:
ڲݴڿؼReferenceֵַ
Ʋ(ƪؼʵ)
 õݴֶθ
iColCount = Integer(dw1.Describe(DataWindow.Column.Count))[ ZK) 
dw1Ϊݴڶ
 ѭԵ1õֶθΪѭεõݴÿֶεֶͺͱʶǴַС
£
ȡֶ
sColName = dw1.Describe(# + String(i) + .name)
ȡֶͣ
sColType = dw1.Describe(# + String(i) + .coltype)
ȡֶαʶ
sColText = dw1.Describe(sColName + 䡪t + .text)
˵ݴʱϵͳȱʡؽֶαʶֶΪֶ+䡪t
еdw1Ϊڲi ָڼֶΡ
 شַ
. ѯ
:
ڲַϵúؽֵַʽ
ҪؼΪһݴںһťͼ1

ͼ1òѯʾ
ݴڿؼڹʽӦݴڶڲԭݴйزΪԴԴΪⲿExternalResult Setɣ
 ֶαʶڲṩڴopen¼ɣ༭ʽΪбʾֵDisplay ValueӦڲsColTextֵData ValueӦڲsColName
 ϵ༭ʽΪб
 ֵû롣
 ߼༭ʽΪб
ťݴڵûһַʽء
йصĳҪУ
open¼
 ȡĲǴݴڱʶֶεı༭ʽС
dw1.Modify(#1.values = " + Message.StringParm + ")
ע⴫Message.StringParmϱ༭ʽĶʽ 1ݴǲһУȴû롣
ݴڵitemchanged¼ݴеǰежʱԶһУȴûһе루ԣ
ťclicked¼
 ɾС
 㵱ǰݴΪգ򷵻ؿֵݴΪѭȡֵֶֶ;ʾʽ߼ϸַзء˷صַΪļʽ
2.1.2ӡԤ
ڶݴ²壺߽硢ֽųߴ硢ӡԤűӦ
£
ڲݴڶ󡡡ֵ
ڳݴڿؼ⣬ҪĿؼɷΪࣺࡢࡣ
ݴԭݴڵһڵвԴ˿ݴڽСֱӶԭݴڽвҲǻͨԵĿǡ
ؼһΪб༭ʽб򣬹ûôӡ
ؼһΪť
йصĳҪУ
ڵopen¼
 ȡڲݴ˲ݴԴ
dw1.Create(dwsource.Object.DataWindow.Syntax) dwsourceΪԭݴ
 ȡݴйشӡӦĿؼСйزУ߽硢ֽųߴ硢ӡҳ

ͼ2ôӡԤʾ
ȡ߽Ϊ
ȡϱֵ߽emtop.text=dw1.Object.DataWindow.Print.Margin.Topȡ߽λsttopunit.text = PBU ȡõλ0䣬 1䣬 2䣬 3 Ӧظpbu䣬 pxl䣬 in䣬 cmֵ
ȻÿҪãǵĲͬģ
 áModifyʵ֡
Ա߽Ϊ
dw1.Modify("datawindow.print.margin.top="
+emtop.text+&
"datawindow.print.margin.bottom="+embottom.text+&
"datawindow.print.margin.left="+emleft.text+&
"datawindow.print.margin.right="+emright.text)
 ¼ҳ統ǰݴԤ״̬£ֱӼıݴԤ̬¼㣬ϣٸıԭ״̬
ҳ
iCount = dw1.Describe ("Evaluate(PageCount(),0)")
ıԤ״̬
dw1.Modify("datawindow.print.preview=yes")
ڴӡһôӡڣôӡѡӡΧӡʽ桢żԶҳӡӡ򣨵ļӡȡƪ׸
Ҫ˵ǣֻǳõĹôϷԽĹôڡ
2.2ؼ
롢ɾҲݴھҪʹõĲԶؼʵЩһֿеķ·ƵԶؼڸֱӱʹá
ɾΪ˵Ʒơɾű£
//ע⣺ԶֻԸ
//ֻһݴڵ
//縸жݴ,
//ѡȡǰݴΪ
Window wParent
GraphicObject gbWhichControl
DataWindow dwHere

integer iCount,i

wParent=PARENT
iCount = UpperBound(wParent.Controlۣ)

//Ѱҵǰепؼֱҵݴ
FOR i = 1 TO iCount
gbWhichControl = wParent.Controli
CHOOSE CASE TypeOf(gbWhichControl)
CASE DataWindow!
dwHere=gbWhichControl
EXIT
END CHOOSE
NEXT

//ɾ
dwHere.DeleteRow(0)
γУִɾֻ漰һУĳͨеơ
๫ö󣺴ͿؼࡣȻ๫öʱҲԻôпֱʹùÿؼÿؼҲԵùôڡ
3
òɹö빫ÿУʱֱӵûʹǣһЧʺͿάԺõƷڴͿĿУƷԽԸΪԡڱУΪ֤öͨԣȡ˲ݵķȻΪ˻ͨԣһЧʡ
ڳƺ׫дĵĹУõ人ӿƼ޹˾Ĵڴл⣡
߼飺񻪡ʦ
󡡸ڡ
ǽ ڡ¼缰ӦõĽѧС
ߵλйʴѧġ.人430074)
ο
1ݡBiberdorf,D,.PowerBuilder 5Աָ.Ⱥ,.еҵ磬1997,9
ո:1998-12-27(޸ĸ)
