发表于:2007-06-10 16:51:00
楼主
我想通过复选框的勾选更新SQLServer数据库中TestPointInfo表的SaveFlag列的值,InTouch脚本如下:
IF Flag == 1 THEN
SQLSetStatement(Connection_Id,"Update TestPointInfo set SaveFlag = 1 where sysId = 1");
ELSE
SQLSetStatement(Connection_Id,"Update TestPointInfo set SaveFlag = 0 where sysId = 1");
ENDIF;
SQLExecute(Connection_Id,"NULL",0);
以上脚本在InTouch9.5中正常执行,但在InTouch7.0中SQLExecute(Connection_Id,"NULL",0);这句执行不了,我测试了SQLSetStatement这句没问题,返回值是0,就是SQLExecute这句有问题,返回值不是0. 可是查InTouch7.0的帮助文档有这样的SQL函数呀,到底是为甚么?请各位大侠不吝赐教!!!