以下是引用qq402716710在2013-3-11 12:35:59的发言:
=SQLEXEC(SQL句柄,"select NAME REC_NUM from sysobjects WHERE UPPER(NAME)='过程名' AND UPPER(TYPE)='P'","tmp")
if RECCOUNT('tmp')>0 &&存在
=sqlexec(SQL句柄,"过程名")
endif
=号前面不带参数,运行的时候说找不到参数,但是加上参数就说语法错误..
原是 =SQLEXEC(SQL句柄,"select NAME REC_NUM from sysobjects WHERE UPPER(NAME)='过程名' AND UPPER(TYPE)='P'","tmp")
if RECCOUNT('tmp')>0 &&存在
=sqlexec(SQL句柄,"过程名")
endif
=号前面不带参数,运行的时候说找不到参数,但是加上参数就说语法错误..
=SQLEXEC(SQL句柄,"select NAME REC_NUM from sysobjects WHERE UPPER(NAME)='过程名' AND UPPER(TYPE)='P'","tmp")
其中的SQLEXEC( 的( 作了全角了,你改成半角 即:
=SQLEXEC(SQL句柄,"select NAME REC_NUM from sysobjects WHERE UPPER(NAME)='过程名' AND UPPER(TYPE)='P'","tmp")