这段代码很奇葩！

[ah_2055]

set nocount on select id=identity(int , 1,1),t.* into #a from (select a from dbo.SplitString((select ChannlCode from CustomMainInf where CreditNm='13016000001' ),'-')) as t select * from ProductionDesin where ID =(select a from #a where id=(select max(id) from #a)) drop table #a

前台语言是VB6+ADO,调用的时候居然只能rst.fields(2)数字。
如果。rst.fields("字段名称")
就会报错，找不到记录集，搞不懂。。

[Mr_Nice]

整理了一下，没发现有啥问题...

SELECT  id = IDENTITY( INT , 1,1 ),
        t.*
INTO    #a
FROM    ( SELECT    a
          FROM      dbo.SplitString(( SELECT    ChannlCode
                                      FROM      CustomMainInf
                                      WHERE     CreditNm = '13016000001'
                                    ), '-')
        ) AS t 
						
SELECT  *
FROM    ProductionDesin
WHERE   ID = ( SELECT   a
               FROM     #a
               WHERE    id = ( SELECT   MAX(id)
                               FROM     #a
                             )
             ) 
 
drop table #a

[ah_2055]

代码是没问题，你用ADO调用试试，是不能赋rst.fields("字段名称")这种办法进行

[DBA_磊仔]

rst.FieldByName("字段名称")