
COMPUTER ENGINEERING
1999 25 12 vol.25 No.12 1999



PBģбʾ̬
ҡΡ
1 
PB(PowerBuilder)һĻڿͻʽݿ⿪ߣ˴¼Ϊǿ󡢸ܵĿ ¼̷ʽڿӻУ֤ݰȫǰ£ʹԱԼĲƷ 
ʹùPB˶֪WindowУṩ˶ֿÿؼ˻ϢĽӿڽ棬Ӧóͨϵչָûġ Ӧóֻͨؼʹãܷ书ܡ ʽбؼDropDownListBox ֮һҲΪϿΪ˵б༭бԣԱ༭һıһԹľοʾı˫беĳʱĳЩ
ȻһǳĿؼṩĹ޵ģбʾڶʱԤڳʱӣֻʺԹ̶ 
ʵӦУִвѯʱΪѯ뷽ʽҪԴ̬ݣݿеݣбķʽṩûѡ룬ˣʱбؼҪ
һڳʱ̬شĳһѡȡģбķ
2 ʵ
2.1 ݴ
1һ͵ֵֻcontentidֶΣcontentҪʾidӦı롣
1 ͵ֵ
NameTypeWidthDecimalNull
contentchar20No
idchar2No

ϢϵͳʱΪʹ淶ͳһߴЧʡʡݿ洢ռ䡢ͬʱܷûҪõֱ ѧ롢Ա롢ʡرȡѧΪϸܡ
Ƚݴڣ
(1) һݴd_education
ݴУԴѡQuick SelectѡʾʽѡGridѡOKŦ󣬽Quick SelectԻTablesѡҪʹõıeducation ColumnsбѡcontentidOKŦʱPBƺõĻͷHeaderأֻDetailƺúݴΪd_education̡
(2) ڶݴd_education_dw
ͬķQuick SelectԻTablesѡҪʹõıeducation Columns бѡcontentid OKŦ󣬽ͷHeaderأֻDetail 
Ȼ༭content : content еҼѡProperties...ʾѡEdit ǩStyle ѡ DropDownDWData window ѡѽõd_educationDisplay ColumnѡcontentData Columnѡid Lines in DropDown ʵбʾ 
ѡV Scroll BarԱб߽ʱԶʾֱѡAlways Show Arrow Աʾһб ƺúݴΪd_education_dw̡
һݴd_education ĿǣΪ˶ڶݴd_education_dw ݴd_education_dwֵһݴd_educationͨݴڵǶϷʽﵽʵģбĿģǱĹؼڡ
2.2 ڼؼ
һΪw_windowϴһݴڿؼdw_1ݴڶd_education_dwģб 
Ȼٴһݴڿؼdw_2ʾݴڣdw_2ݴڶѡԸϢ⣬ڸdw_1ѡֵdw_2еݡ Ҳ˵dw_1dw_2Ĳѯ Ϊdw_2һ뽨ݴڶd_education_dwݵıйأѧ
2.3 ݿݴе
ڼؼ֮󣬻ݿݴ޷ʾݿеݡ 
ڴw_windowopen¼м䣺
Connect Using SQLCA dw_1.SetTransObject(SQLCA)
dw_1.Retrieve() dw_2.SetTransObject(SQLCA ) 
dw_2.Retrieve('00') Disconnect Using SQLCA
2.4 dw_1d_education_dw
Ϊݴdw_2УбֵʾӦݣҪdw_1dw_2ؼӡ
dw_1itemchanged ¼䣺 Connect Using SQLCA dw_2.SetTransObject(SQLCA); dw_2.Retrieve(data) Disconnect Using SQLCA;
3 ʹЧ
ڲѯʱdw_1ûѡӦdw_2ʾĻ̶ȶӦݡ еͻᵯ2.1 жбѡһݣ籾ƣdw_2ݴӦĻ̶ȵݡ ֻҪdw_1еһ仯ͻᴥitemchanged ¼dw_2ݴϾͻ֮Ӧ仯
4 
ʵӦУģб̬ʾݲĳضṹıһһֶΡ̿Եóۣڳʱ̬ʾѡݿеݣģб뷽ʽȫеģʵַҲУͻϵͳṩбܵľԣչϵͳܣշû ͶеĹϢϵͳУô˷Чʵ֤ǼЧġ
ߵλ:ҵѧ,150001
ο
1 ()Hatfield B. PowerBuilder5Ӧó򿪷ָ. 廪 ѧ磬1997
