不一样的, 例如: sql : ='select * from table from 字段='''+Edit1.text+''''
源代码如下 procedure UpdateClick .... begin query.close; query.clear; query.sql.add('select * from A where (条件)'); query.open; query2.clear; query2.sql.add('update A set (... ) '); query2.execsql; 在最后一句就出错了
procedure UpdateClick .... begin query.close; query.clear; query.sql.add('select * from A where (条件)'); query.open; query.close;//// query2.clear; query2.sql.add('update A set (... ) '); query2.execsql;
这样 procedure UpdateClick .... begin query.close; query.Sql.clear; query.sql.add('select * from A where (条件)'); query.prepare; query.open; query.close;//// query2.close; query2.sql.clear; query2.sql.add('update A set (... ) '); query2.execsql;
例如: sql : ='select * from table from 字段='''+Edit1.text+''''
procedure UpdateClick ....
begin
query.close;
query.clear;
query.sql.add('select * from A where (条件)');
query.open;
query2.clear;
query2.sql.add('update A set (... ) ');
query2.execsql;
在最后一句就出错了
begin
query.close;
query.clear;
query.sql.add('select * from A where (条件)');
query.open;
query.close;////
query2.clear;
query2.sql.add('update A set (... ) ');
query2.execsql;
procedure UpdateClick ....
begin
query.close;
query.Sql.clear;
query.sql.add('select * from A where (条件)');
query.prepare;
query.open;
query.close;////
query2.close;
query2.sql.clear;
query2.sql.add('update A set (... ) ');
query2.execsql;