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 |
#2
|
|||
|
|||
How do I tell to recordset that I want all True-fields?
select * from MyDatabase where Field1 0
"hanski" wrote in message oups.com... 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 |
#3
|
|||
|
|||
How do I tell to recordset that I want all True-fields?
There's no need to ask the same question three times in three minutes.
"hanski" wrote in message oups.com... 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 |
#4
|
|||
|
|||
How do I tell to recordset that I want all True-fields?
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: There's no need to ask the same question three times in three minutes. "hanski" wrote in message oups.com... 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 |
#5
|
|||
|
|||
How do I tell to recordset that I want all True-fields?
Thanks a lot Baz!
hanski Baz kirjoitti: select * from MyDatabase where Field1 0 "hanski" wrote in message oups.com... 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 |
#6
|
|||
|
|||
How do I tell to recordset that I want all True-fields?
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: select * from MyDatabase where Field1 0 "hanski" wrote in message oups.com... 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 |
#7
|
|||
|
|||
How do I tell to recordset that I want all True-fields?
Surely,
select * from MyDatabase where Field1 = 0 "hanski" wrote in message oups.com... 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: select * from MyDatabase where Field1 0 "hanski" wrote in message oups.com... 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 | |
|
|