FoxPro 'true' SQL-Syntax?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikael.palmblad@gmail.com - 29 Aug 2006 08:35 GMT

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?

Reply to this Message

Ben Voigt - 31 Aug 2006 18:29 GMT

> Hi!
>
[quoted text clipped - 14 lines]
> where test1 = . T .
> where test1 = 0

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

> Nothing seems to work. Anyone have an idea?

Reply to this Message

mikael.palmblad@gmail.com - 01 Sep 2006 08:15 GMT

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

Ben Voigt skrev:

> > Hi!
> >
[quoted text clipped - 18 lines]
>
> > Nothing seems to work. Anyone have an idea?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...