Skip to Content.
Sympa Menu

freetds - Re: [freetds] parsing T-SQL with flex & yacc (was: segfaultinPerl'sEmail::Store when using freetds)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] parsing T-SQL with flex & yacc (was: segfaultinPerl'sEmail::Store when using freetds)
  • Date: Wed, 22 Feb 2006 20:53:52 -0500

Зверев Виталий Борисович 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




Archive powered by MHonArc 2.6.24.

Top of Page