long li_i,li_n
string ls_xsbh,ls_dsbh,ls_xsbh1,ls_dsbh1
dwItemStatus l_status,l_status1
li_n=dw_1.rowcount( )
for li_i=1 to li_n
// l_status=dw_1.getitemstatus(li_i,'编号',primary!)
// l_status1=dw_1.getitemstatus(li_i,'大赛编号',primary!)
// if l_status=datamodified! or l_status1=datamodified! then
ls_xsbh=dw_1.object.编号.primary.original[li_i]
ls_dsbh=dw_1.object.大赛编号.primary.original[li_i]
ls_xsbh1=dw_1.object.编号.primary.current[li_i]
ls_dsbh1=dw_1.object.大赛编号.primary.current[li_i]
update 投票记录
set 选手编号=:ls_xsbh1,大赛编号=:ls_dsbh1
where 大赛编号=:ls_dsbh and 选手编号=:ls_xsbh;
if sqlca.sqlcode<>0 then
messagebox('提示','更新投票记录时出错')
return false
end if
// end
next
return true
long li_i,li_n
string ls_xsbh,ls_dsbh
li_n=dw_1.deletedcount( )
for li_i=1 to li_n
ls_xsbh=dw_1.object.编号.delete.original[li_i]
ls_dsbh=dw_1.object.大赛编号.delete.original[li_i]
delete from 投票记录
where 大赛编号=:ls_dsbh and 选手编号=:ls_xsbh;
if sqlca.sqlcode<>0 then
messagebox('提示','更新投票记录时出错')
return false
end if
next
return true
string ls_xsbh,ls_dsbh,ls_xsbh1,ls_dsbh1
dwItemStatus l_status,l_status1
li_n=dw_1.rowcount( )
for li_i=1 to li_n
// l_status=dw_1.getitemstatus(li_i,'编号',primary!)
// l_status1=dw_1.getitemstatus(li_i,'大赛编号',primary!)
// if l_status=datamodified! or l_status1=datamodified! then
ls_xsbh=dw_1.object.编号.primary.original[li_i]
ls_dsbh=dw_1.object.大赛编号.primary.original[li_i]
ls_xsbh1=dw_1.object.编号.primary.current[li_i]
ls_dsbh1=dw_1.object.大赛编号.primary.current[li_i]
update 投票记录
set 选手编号=:ls_xsbh1,大赛编号=:ls_dsbh1
where 大赛编号=:ls_dsbh and 选手编号=:ls_xsbh;
if sqlca.sqlcode<>0 then
messagebox('提示','更新投票记录时出错')
return false
end if
// end
next
return true
long li_i,li_n
string ls_xsbh,ls_dsbh
li_n=dw_1.deletedcount( )
for li_i=1 to li_n
ls_xsbh=dw_1.object.编号.delete.original[li_i]
ls_dsbh=dw_1.object.大赛编号.delete.original[li_i]
delete from 投票记录
where 大赛编号=:ls_dsbh and 选手编号=:ls_xsbh;
if sqlca.sqlcode<>0 then
messagebox('提示','更新投票记录时出错')
return false
end if
next
return true