Tquery里面有这么一个语句:Insert into KK_ACCOUNT
VALUES(:NO,:CODE,:SIZETYPE,:INDATE,NULL,:USERID_IN,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)NO,CODE,SIZETYPE,INDATE,USERID_IN 我想用参数传进去,结果提示错误:error creating cursor handle.该怎么改程序?
VALUES(:NO,:CODE,:SIZETYPE,:INDATE,NULL,:USERID_IN,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)NO,CODE,SIZETYPE,INDATE,USERID_IN 我想用参数传进去,结果提示错误:error creating cursor handle.该怎么改程序?
------------------是表。
现在是Tquery不能active~~不是传参数的时候出错~~
WITH KKACOUNTINSERT DO
BEGIN
KKACOUNTINSERT.Active := FALSE;
KKACOUNTINSERT.ParamByName('NO').ASSTRING := NO ;
showmessage(NO);
KKACOUNTINSERT.ParamByName('CODE').ASSTRING := CODE;
KKACOUNTINSERT.ParamByName('SIZETYPE').ASSTRING := SIZETYPE;
KKACOUNTINSERT.ParamByName('INDATE').asdatetime := strtodatetime(INDATE);
KKACOUNTINSERT.ParamByName('USERID_IN').asstring := USERID_IN;
KKACOUNTINSERT.Active := TRUE;
END
WITH KKACOUNTINSERT DO
BEGIN
//KKACOUNTINSERT.Active := FALSE;
KKACOUNTINSERT.ParamByName('NO').ASSTRING := NO ;
showmessage(NO);
KKACOUNTINSERT.ParamByName('CODE').ASSTRING := CODE;
KKACOUNTINSERT.ParamByName('SIZETYPE').ASSTRING := SIZETYPE;
KKACOUNTINSERT.ParamByName('INDATE').asdatetime := strtodatetime(INDATE);
KKACOUNTINSERT.ParamByName('USERID_IN').asstring := USERID_IN;
KKACOUNTINSERT.ExecSQL;
//KKACOUNTINSERT.Active := TRUE;
END
哈哈,果然,不用了就ok了~~~谢谢36