How do I tell to recordset that I want all True-fields?

[hanski]

Hi.

I have a simple recordset:

Dim Town as New ADODB.connection
Dim Base as New ADODB.recordset
....
....

open.Base "select * from MyDatabase where Field1 =
true",Town,adOpenDynamic, adLockOptimistic

And when I start it, it says:" Invalid column name 'true'.

Field1 has bit-type.

How can I tell it that I want to have all fields that have value True?


Hannu

 

[Baz]

select * from MyDatabase where Field1 <> 0

 

[Baz]

There's no need to ask the same question three times in three minutes.

 

[hanski]

I send my question 3 times and every time came response: Server error.
Can't send your message. Try later again". I was going to send my
question fourt time but then I noticed, it was there. Not my fault.


Baz kirjoitti:

 

[hanski]

Thanks a lot Baz!


hanski


Baz kirjoitti:

select * from MyDatabase where Field1 <> 0

 

[hanski]

One more problem!

select * from MyDatabase where Field1 <> 0, gives me really every true-
statements, but when I want False-statements select * from MyDatabase
where Field1 <> -1 won't work! How do you do it when you want
false-statements?




Baz kirjoitti:

 

[Sean]

Surely,

select * from MyDatabase where Field1 = 0