用友的凭证update

select pk_glorgbook from bd_glorgbook where glorgbookcode=‘0100-0001‘;--0001N510000000006K4X
select no,period,year,dr,pk_voucher from gl_voucher where no=‘68‘ and dr=‘0‘ and period=‘01‘ and year=‘2014‘ and 
pk_glorgbook=‘0001N510000000006K4X‘;
update gl_voucher set no=‘69‘ where pk_voucher=‘1162N51000000001YHZ3‘;
update gl_detail set nov=‘69‘where pk_voucher=‘1162N51000000001YHZ3‘;

select no,period,year,dr,gl_voucher.explanation, pk_voucher from gl_voucher where no in(‘153‘,‘156‘,‘154‘,‘287‘ )
and dr=‘0‘ and period=‘04‘ and year=‘2014‘ and pk_glorgbook=‘0001N510000000006K4X‘ for update;