If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I tell to recordset that I want all true-fields?
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 |
Thread Tools | |
Display Modes | |
|
|