FoxPro 'true' SQL-Syntax?

[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?

 

[Ben Voigt]

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"?

 

[mikael.palmblad]

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

Ben Voigt skrev: