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



Զ̬޸ĵݿϵͳ

ժҪĽPowerBuilder6.0Ķ̬Dynamicݴ(DataWindow)޸ݿƣұ޸ĵİ취
ؼʡݴڣݿ
ʵʵݿ⿪УûҪϣܹҵ˾ı仯ʵʱݿƽеЩľݿϵͳĿƽ׶ǲȷġҪݿϵͳõԺͿԡ
PowerBuilder6.0Ϊߣܾʵַ
1˼
PowerBuilder6.0Ķ̬ݴ(DataWindow)޸ݿơͬʱһӵıЩƵ޸ϢڸñСʹ˴޸ĿԱ浽´޸Ϊֹ
2ݴڵĶ̬޸ļ
ݴеСıťͼƬΪݴڶDwobjectǶԼԡ
̬ͨشݴڶеĶݴڶԼݴڶжԡݴڿеݿԴﵽ޸ݴ۵Ŀġ
зݴڶķ
. ʹdescribe( )modify( )
ȡݴnameбɫbackground.colorֵ
dw1.describe("name. Background.color")
ݴnameбɫΪɫ
dw1.modify("name. Background.color=
string(rgb(255,255,255))" )
. ʹݴڱʽ
ݴڱʽʹõ.ָʾҪʵĶ󡢶еĶԼԡ﷨Ϊ
dwcontrol.object.dwobjectname.
{ .object.dwobjectname .}{.property}=value 
ݴnameбɫΪɫ
dw1.object.name.background.color
=rgb(255,255,255)
ƹʹõݴڱʽ
3Ʋ
3.1ṹ
PowerBuilder6.0ݿ⻭ʣDataBase Painterжṹ
磬ְԱϢpersonnelṹΪ  
personnel
PeridChar(30)NOT NULL
Pername Char(10)NOT NULL
PerdepartmentChar(20)NOT NULL
ӦheaderlabelΪ
ID

ڲ
ͬʱ屣defineṹΪ 
define
PeridnameChar(30)NULL
Pernamename Char(10)NULL
PerdepartmentnameChar(20)NULL 
ӦheaderlabelΪ
һ
ڶ

3.2ݴڶ
PowerBuilder6.0ݴڻʣDataWindow Painterݴڶ
. ΪְԱϢpersonnelݴڶdpersonnelPowerBuilder6.0ԶеӦıʾеheaderlabelֵΪ:
Peridt 
Pernamet 
Perdepartmentt
ͨ޸ЩıtextԴﵽ޸ƵĿġ 
. Ϊdefineݴڶddefine 
3.3û
PowerBuilder6.0ĴڻʣWindow Painter崰ڶ
3.3.1ְԱϢ
. ְԱϢڶw1
. ڴϷݴڿؼdw1֮ݴڶdpersonnelӣdw1ʾΪvisible
. ڴϷݴڿؼdw2֮ݴڶddefineӣڴڻнdw2ʾΪinvisible
W1open¼ĴΪ
{ 
dw1.settransobject(sqlca)
dw2.settransobject(sqlca)
//dw2ΪصƵı
dw1.retrieve()
dw2.retrieve()
dw1.object.peridt.text=dw2.getitemstring(1,1)
dw1.object.pernamet.text=dw2.getitemstring(1,2)} 
dw1.object.perdepartmentt.text=dw2.getitemstring(1,3) 
} 
. ڴϷðťؼ޸ơcb1
cb1clicked ¼ĴΪ 
{ open(w2) 
// ڵ3.3.2дƱ洰w2
}
w1ڵͼ1

ͼ1
3.3.2Ʊ洰
. Ʊ洰ڶw2
w2open¼ĽűΪ 
{ 
dw2.settransobject(sqlca)
dw1.retrieve()
} 
. ڴϷݴڿؼdw1֮ݴڶddefineӡ
. ڴϷðťؼ桱cb1cb1clicked¼ĽűΪ
{ 
if update(dw1)=1 then 
commit ;
messagebox("ok!","ɹ!")
else 
rollback ;
messagebox("pity!","ʧ!")
end if
}
w2ͼ2

ͼ2
PowerBuilder6.0Ķ̬ݴڼ޸ӦóۣصݴڱЩĶû˼·ƹ㵽ӦС
߼飺顡˶ʿоҪ¼ӲMISݿӦϵͳо
ߵλйѧԺռҡ100080
ո:1999-06-18
