FoxPro 'true' SQL-Syntax?

  • Thread starter Thread starter mikael.palmblad
  • Start date Start date
M

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?
 
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
Click to expand...

Have you tried "WHERE test1" and "WHERE NOT test1"?
 
Wow! It worked. How simple. Never thought of it though. Thanks a
million!

Ben Voigt skrev:
 
Back
Top