StoredProc显示数据的问题!
CREATE PROCEDURE PROtoExcel
@EXN varchar(250)
AS
select * into #temp1 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="D:\Excel2005\28.xls";User ID=Admin;Password=;Extended properties=Excel 5.0;Persist Security Info=false')...[sheet1$]
select 序号 as orderNO,货号 as productNO,品名 as productName,规格 as specification,单位 as Unit,数量 as Quantity,完成 as finished,备注 as Remark from #temp1
GO
上面的存储过程在查询分析器中执行能返回正确结果如下:
orderNO productNO productName specification Unit Quantity finished Remark
1 CK0001 AA BB 3 10 YY 2005
2 CK0002 KK CC 5 15 YY 2005
但是在窗体上放一个TStoredProc控件后,在Object TreeView-->StoredProc1-->点Fields右键添加-->Add all fields 只看到有三个字段orderNO,Quantity ,Remark。
按理说应该显示存储过程查询返回的全部字段:
orderNO productNO productName specification Unit Quantity finished Remark
现在为什么只显示三个字段????各位帮帮!TKS!