Query1.SQL.Clear;
Query1.SQL.Add('select * into "c:\sjsgf.dbf" from "h:\qs\sjsgf.dbf" where gfgddm in (select stock_a005 from "h:\qshbf\stockacc")');
Query1.Open;
Query1.SQL.Add('select * into "c:\sjsgf.dbf" from "h:\qs\sjsgf.dbf" where gfgddm in (select stock_a005 from "h:\qshbf\stockacc")');
Query1.Open;
可以吗?
"select * into "这是什么啊
另外,我印象里select into是用来创建一个表的,你那个c:\sjsgf.dbf是不是已经存在?不能肯定,不过insert一定是可以的.
insert into "c:\sjsgf.dbf" select * from "h:\qs\sjsgf.dbf" where gdgddm in (select stock_a005 from "h:\qshbf\stockacc")这两句语句的意思是不一样的!前一句的意思是要建立一个原来不存在的表,后一句是插入一个已经存在的表记录!
多交流呀!
Project XXX raised exception class ENoResultSet with message‘Error
creating cursor handle’。Process Stopped。Use Step or Run to
Continune。
怎么回事呀!!!!
: Query执行inser和delete方法应该用Query.ExeSQL
: 而不能用open