How VBA accepts "true" in recordset?

H

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
 
K

kingston via AccessMonster.com

Try:

... WHERE Field1=-1...
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I tell to recordset that I want all True-fields? 6
How can I find the count of fields in vba? 1
How to see my sql in recorset? 2
Date Format problem in recordset 3
Why my recordset is not working? 2
Copy and create recordset 2
Runtime Error 3001 Arguments Are Of The Wrong Type, Are Out Of TheAcceptable Range, or are in confli 4
Recordset problem 1

Top