摘要： //1.informix 数据库 更新表索引，提高查询效率。//update statistics for table year_decrsubjtotal1.生成raq中使用的datestart ,代码在form 表达中。 var d_s = form.datekey.value; var d_start = d_s.substr(0,4); var m = d_s.substr(5,2); if(m=='04' || m=='05' || m=='06'){ d_start = d_start+"-04-01"; }els 阅读全文

摘要： 6个柜面交易 打印修改--050101 delete from tran_prints where tran_id = (select id from tran where code='050101'); insert into tran_prints values(tran_prints_seq.nextval, (select id from tran where code='050101'), (select id from prints where name = '二联通用凭证'), 1); delete from tran_def_im 阅读全文

摘要： 1. 10.10.20.88 weblogic/weblogicbhrs/WebRoot/reportfiles/cbs/raq 5939_1.raq 5940_1.raq 2. 10.10.3.42 更新程序 financial_product_report.c 3. 199.1.1.11 数据库添加 字段select * from lccpmx;alter table lccpmx add jyqd CHAR(64);update lccpmx set jyqd='柜面渠道' ; alter table lccpmx modify (jyqd CHAR(64) not nu 阅读全文