FoxPro 'true' SQL-Syntax?

29 Aug 2006 7:35 AM

mikael.palmblad

Hi!

Easy question.

How do I compare a bit-column that has "True" and "False" in .NET
framework Query Designer?
I've made a connection to a Visual FoxPro database (ODBC-connection).
I've tried several things like:

select test1 from table1

where test1 = true
where test1 = 'true'
where test1 = 'True'
where test1 = 1
where test1 = .T.
where test1 = . T .
where test1 = 0

Nothing seems to work. Anyone have an idea?

31 Aug 2006 5:29 PM

Ben Voigt

<mikael.palmb***@gmail.com> wrote in message
Show quote

news:1156836908.227074.110910@i3g2000cwc.googlegroups.com...
> Hi!
>
> Easy question.
>
> How do I compare a bit-column that has "True" and "False" in .NET
> framework Query Designer?
> I've made a connection to a Visual FoxPro database (ODBC-connection).
> I've tried several things like:
>
> select test1 from table1
>
> where test1 = true
> where test1 = 'true'
> where test1 = 'True'
> where test1 = 1
> where test1 = .T.
> where test1 = . T .
> where test1 = 0

Have you tried "WHERE test1" and "WHERE NOT test1"?

Show quote

>
> Nothing seems to work. Anyone have an idea?
>

1 Sep 2006 7:15 AM

mikael.palmblad

Wow! It worked. How simple. Never thought of it though. Thanks a
million!

Ben Voigt skrev:

Show quote

> <mikael.palmb***@gmail.com> wrote in message
> news:1156836908.227074.110910@i3g2000cwc.googlegroups.com...
> > Hi!
> >
> > Easy question.
> >
> > How do I compare a bit-column that has "True" and "False" in .NET
> > framework Query Designer?
> > I've made a connection to a Visual FoxPro database (ODBC-connection).
> > I've tried several things like:
> >
> > select test1 from table1
> >
> > where test1 = true
> > where test1 = 'true'
> > where test1 = 'True'
> > where test1 = 1
> > where test1 = .T.
> > where test1 = . T .
> > where test1 = 0
>
> Have you tried "WHERE test1" and "WHERE NOT test1"?
>
> >
> > Nothing seems to work. Anyone have an idea?
> >