FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Зверев Виталий Борисович wrote:
> I'm still digging of placeholder's parser and begin thinking about
> correlations with Pandor's box. 

        ;-)

> select count(1) as cnt ,type into #temp1 from sysobjects group by type ;
> 
> select cnt,type from #temp1 where cnt > ?
> 
> How to get datatype of placeholder (#temp1.cnt)? 
...
> The native MS odbc driver give me an answer ;) :
> SET FMTONLY ON select  cnt from sysobjects where 1=2 SET FMTONLY OFF
> Error :[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column
> name 'cnt'.

'cnt' is not a column in sysobjects.  Perhaps you want:

        SET FMTONLY ON 
        select cnt from #temp1 where 1=2 
        SET FMTONLY OFF

Is that any help?  

Regards, 

--jkl