Bit column in FoxPro GUI

I have to pull data from a SQL app for a WIN-Form app in .NET, where data is
stored in FoxPro. Seems that the bit data type is not casting properly
through the ODBC driver back to FoxPro'
Any way to cast or convert a bit column? When I did case when IsPrint = 0
then ' 0' else '1' end IsPrint but that barfed?
Any ideas?How about CAST(bitcol AS int)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Stephen Russell" <srussell@.lotmate.com> wrote in message
news:%23bEzNe6DFHA.328@.tk2msftngp13.phx.gbl...
>I have to pull data from a SQL app for a WIN-Form app in .NET, where data i
s
> stored in FoxPro. Seems that the bit data type is not casting properly
> through the ODBC driver back to FoxPro'
> Any way to cast or convert a bit column? When I did case when IsPrint = 0
> then ' 0' else '1' end IsPrint but that barfed?
> Any ideas?
>
>|||"Stephen Russell" <srussell@.lotmate.com> wrote in message
news:%23bEzNe6DFHA.328@.tk2msftngp13.phx.gbl...
> I have to pull data from a SQL app for a WIN-Form app in .NET, where data
is
> stored in FoxPro. Seems that the bit data type is not casting properly
> through the ODBC driver back to FoxPro'
cast (ap_noprint as int) ap_noprint
Worked fine.