error creating cursor handle
AnsiString s="update Accessory set price=(select newprice from tiaojiabiao ";
s+="where erp_id=Accessory.erp_id) where erp_id='";
qry->Open();
s+=qry->FieldByName("erp_id")->AsString+"'";
qry->Close();
qry->SQL->Clear();
qry->SQL->Add(s);
qry->ExecSQL();
SQL语句在数据库里面执行运行正确,请问为什么出错?
相关推荐
Oracle Database 10g PL-SQL Programming
1 Introduction to PL/SQL .... 3 2 Using SQL*Plus and JDeveloper .... 23 3 PL/SQL Basics .... 45 4 Using SQL with PL/SQL .... 117 5 Records .... 181 6 Collections .... 213 7 Error Handling ... 303 8 Creating Procedures, Functions, and Packages .... 335 9 Using Procedures, Functions, and Packages .... 381 10 Database Triggers .... 443 PART II Advanced PL/SQL Features 11 Intersession Communication .... 499 13 Dynamic SQL .... 583 14 Introduction to Objects ... 635 15 Objects in the Database ... 673 16 Large Objects ... 711 17 Scheduling Tasks .... 767
SqlServer中查看当前Open的Cursor方法
遇到错误:A cursor with thename ‘ ‘ already exists,想要看是什么代码导致的。找到下面几种方法. --测试声明Cursor并且打开 DECLARE vend_cursor CURSOR FOR SELECT * FROMPurchasing.Vendor OPEN vend_cursor FETCH NEXTFROMvend_cursor; --使用下面的三种方法都可以 SELECT ec.session_id,ec.name,ec.properties,ec.creation_time,ec.is_open,ec.writes,ec.reads,
Pro*C/C++ Programmer’s Guide, 10g Release 2 (10.2)
Oracle官方文档 Pro*C/C++ Programmer’s Guide, 10g Release 2 (10.2)
Sql语句_SQL语句_plsql_
plsql 语句命令
Oracle 存储过程异常处理.docx
Oracle 存储过程异常处理.docx


