ADOQUERY吗 直接写select * from table where condition 就可以返回结果集体了 with ADOQuery1 do begin close; sql.clear; sql.add(select field1,field2,... from table1) open; end; 就有结果了啊, adoquery1.recordcount;//记录数; adoquery1.fieldbyname('field1').vlaue;//当前记录fieldbyname1的值
不能用ADOQuery1.OPEN,试试ADOQuery1.ExecSQL
select * into #T from table1 Select * from #T两句写在一起,再用OPEN应该也可以!
select * into ##Temp from table1//全局临时表
CREATE TABLE #temp_rpt_Stock(
tmp_Customer_No varchar(50),
Item_No01 varchar(50),
Item_No02 varchar(50),
Item_No03 varchar(50),
Item_No11 varchar(50),
Item_No12 varchar(50),
Item_No13 varchar(50),
--Date_Str varchar(20),
Stock_In int,
Stock_Out int,
Stock_Out_2B int,
Stock_Else int,
Stock_Remains int,
Booker varchar(20)--first employee_no and then update to employee_name )
直接写select * from table where condition
就可以返回结果集体了
with ADOQuery1 do
begin
close;
sql.clear;
sql.add(select field1,field2,... from table1)
open;
end;
就有结果了啊,
adoquery1.recordcount;//记录数;
adoquery1.fieldbyname('field1').vlaue;//当前记录fieldbyname1的值
Select * from #T两句写在一起,再用OPEN应该也可以!