固定资产卡片修改报错问题

/*

2013-9-18，小科问题

原本固定资产8月启用，后想改成9月启用，改完之后

修改卡片就报错，EOF或BOF

*/

use ufdata_001_2013

go

update fa_cards set  iinputperiod='9'

go

update fa_q_Cards set dbldeprT9=dbldeprT8

update fa_q_Cards set ldeprmonths9=ldeprmonths8

update fa_q_Cards set lusedmonths9=lusedmonths8

update fa_q_Cards set dblmonthvalue9=dblmonthvalue8

update fa_q_Cards set dbldeprT8=0

update fa_q_Cards set ldeprmonths8=0

update fa_q_Cards set lusedmonths8=0

update fa_q_Cards set dblmonthvalue8=0

go

update fa_DeprTransactions set  iinputperiod='9'

update fa_DeprTransactions set dbldeprT9=dbldeprT8

update fa_DeprTransactions set ldeprmonths9=ldeprmonths8

update fa_DeprTransactions set lusedmonths9=lusedmonths8

update fa_DeprTransactions set dblmonthvalue9=dblmonthvalue8

update fa_DeprTransactions set dbldeprT8=0

update fa_DeprTransactions set ldeprmonths8=0

update fa_DeprTransactions set lusedmonths8=0

update fa_DeprTransactions set dblmonthvalue8=0

go

update fa_total set iperiod='9'

go

update fa_Cards set lUsedMonths=DateDiff(m, dstartdate,'2013-8-1') 

go

update fa_q_Cards  

set fa_q_Cards.linputdeprmonths=fa_Cards.lUsedMonths

from fa_q_Cards  

left join fa_Cards   

on fa_q_Cards.scardnum=fa_Cards.scardnum

go

update fa_q_Cards  set ldeprmonths9=linputdeprmonths

update fa_q_Cards set lusedmonths9=linputdeprmonths

update fa_q_Cards set lusedmonths=linputdeprmonths

go

update fa_DeprTransactions  

set fa_DeprTransactions.linputdeprmonths=fa_Cards.lUsedMonths

from fa_DeprTransactions  

left join fa_Cards   

on fa_DeprTransactions.scardnum=fa_Cards.scardnum

go

update fa_DeprTransactions  set ldeprmonths9=linputdeprmonths

update fa_DeprTransactions set lusedmonths9=linputdeprmonths

go