如果使用not shared属性,那么这段代码就会出错
passthrough sql must be share! wwqry_cx.Close ;
wwqry_cx.SQL.Clear ;
wwqry_cx.SQL.Add ('SELECT * FROM SLSFCSTKL WHERE');
//第一次审核:录入日期,录入人代码不为空
wwqry_cx.SQL.Add (' AND IENTER_DATE IS NOT NULL ');
wwqry_cx.SQL.Add (' AND IENTER_HUMAN_CODE<>'''' AND IENTER_HUMAN_CODE IS NOT NULL ');
//第二次审核: 质检日期, 质检人代码不为空
wwqry_cx.SQL.Add (' AND ISURE_DATE IS NOT NULL ');
wwqry_cx.SQL.Add (' ISURE_HUMAN_CODE<>'''' ISURE_HUMAN_CODE IS NOT NULL ') ;
//第三次审核: 验收日期,验收人代码不为空 且验收代码不为N
wwqry_cx.SQL.Add (' AND IACCEPT_DATE IS NOT NULL ');
wwqry_cx.SQL.Add (' AND IACCEPT_HUMAN_CODE<>'''' AND ISURE_HUMAN_CODE<>''N''');
wwqry_cx.SQL.Add (' AND IACCEPT_HUMAN_CODE IS NOT NULL ');
wwqry_cx.Open ;
ChineseShow();
passthrough sql must be share! wwqry_cx.Close ;
wwqry_cx.SQL.Clear ;
wwqry_cx.SQL.Add ('SELECT * FROM SLSFCSTKL WHERE');
//第一次审核:录入日期,录入人代码不为空
wwqry_cx.SQL.Add (' AND IENTER_DATE IS NOT NULL ');
wwqry_cx.SQL.Add (' AND IENTER_HUMAN_CODE<>'''' AND IENTER_HUMAN_CODE IS NOT NULL ');
//第二次审核: 质检日期, 质检人代码不为空
wwqry_cx.SQL.Add (' AND ISURE_DATE IS NOT NULL ');
wwqry_cx.SQL.Add (' ISURE_HUMAN_CODE<>'''' ISURE_HUMAN_CODE IS NOT NULL ') ;
//第三次审核: 验收日期,验收人代码不为空 且验收代码不为N
wwqry_cx.SQL.Add (' AND IACCEPT_DATE IS NOT NULL ');
wwqry_cx.SQL.Add (' AND IACCEPT_HUMAN_CODE<>'''' AND ISURE_HUMAN_CODE<>''N''');
wwqry_cx.SQL.Add (' AND IACCEPT_HUMAN_CODE IS NOT NULL ');
wwqry_cx.Open ;
ChineseShow();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货