在 execute function execsql(v_Sql) into li_sqltext; 该语句时候,报告-1213错误 v_Sql = insert into tmp_datacheck Select Sett_RuleId ,remark From CCS_SettRule Where Protocol_Id Not In(Select Protocol_Id From CCS_Protocol Where State In( '50A','50N' ) And Exp_Date >; Current And sett_type = 'O') And State In( '50A','50N') And Exp_Date >; Current and sett_type = 'O'; 在单独执行 v_Sql语...
by dgguo - Informix - 2003-07-09 09:05:03 阅读(1325) 回复(2)
以前一直没碰过SQL,内容比较简单,自用,这次总结一下用法;
在查询分析器中执行如下: declare @B varchar(20) exec Proc_MakeNewNo \'2004\',\'否\',@B output print @B 得到返回的参数 以前执行返回结果集的方法是这样: Sql.Clear; sql.Add(\'exec aaa \'\'\'+edit1.Text+\'\'\',\'\'\'+TZBX+\'\'\'\'); open; 如果现在执行的存储过程要传送两个参数过去,返回一个参数用adoquery有办法实现吗? 还是一定要用到TADOStoredProc?
软件环境:Delphi7.0(win98) + Sybase 11.0.3(sco unix5.05) 我发现能够成功连接到数据库,得到数据表名称及记录内容, 在用query控件执行SQL命令时,比如执行query1.open或 query1.execsql命令时,出现错误提示!如下: Project DbConnect.exe raised exception class EDBEngineERRor with message 'General SQL error. Cannot find the requested character set in Syschersets: name= 'cp850'.'. Process stoped. Use Step or ...