大家好!
这是数据库里的存储过程:
alter proc findsubjects
as
begin
declare @t table(code varchar(20),name varchar(50),Pcode varchar(20),path varchar(200))
insert into @t select 科目编码,科目名称,上级科目编码,right('---'+科目编码,4) from Tabsubjects where 上级科目编码='R'
while @@rowcount <> 0
begin
insert into @t
select b.科目编码,b.科目名称,b.上级科目编码,a.path+right('---'+b.科目编码,4)
from @t a,dbo.Tabsubjects b
where a.code=b.上级科目编码 and not exists(select 1 from @t where code=b.科目编码)
end 但在VB里把此存储过程赋给MSHFlexGrid控件会提示不支此数据类型.请问应该如何更改才有效?
select code as 科目编码,name as 科目名称,Pcode as 上级科目编码 from @t order by path
end
这是数据库里的存储过程:
alter proc findsubjects
as
begin
declare @t table(code varchar(20),name varchar(50),Pcode varchar(20),path varchar(200))
insert into @t select 科目编码,科目名称,上级科目编码,right('---'+科目编码,4) from Tabsubjects where 上级科目编码='R'
while @@rowcount <> 0
begin
insert into @t
select b.科目编码,b.科目名称,b.上级科目编码,a.path+right('---'+b.科目编码,4)
from @t a,dbo.Tabsubjects b
where a.code=b.上级科目编码 and not exists(select 1 from @t where code=b.科目编码)
end 但在VB里把此存储过程赋给MSHFlexGrid控件会提示不支此数据类型.请问应该如何更改才有效?
select code as 科目编码,name as 科目名称,Pcode as 上级科目编码 from @t order by path
end
---------
应该是程序的问题,