在VB里如何读取临时表的数据啊?
xf2gl 2004-12-14 05:24:01 已有存储过程:
CREATE proc list_material_class(@class nvarchar(50)) as
CREATE TABLE #xc_material_class_temp(
[class1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[class2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[class3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[class4] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[class5] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[class_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[class_sn] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[id] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
。。。。。。。。。。。。省略
GO
临时表在存储过程里已经可以成功生成
但是我在VB里执行一下语句时为什么得不到数据啊:
Conn.Execute "list_material_class '" & class1 & "'"
strsql = "select * from #xc_material_class_temp"
rs.open sresql,conn,1,1
Conn.Execute "drop table #xc_material_class_temp"
请问大侠在VB里如何读取临时表的数据啊?