Home > Archive > Visual Basic > February 2006 > ADO VB/SQL help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| JP Bless 2006-02-23, 6:55 pm |
| I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a long
time and want to move the code to
ADO... I get a clueless error "-2147467259 Automation error - Unspecified
Error" when I run this code. The code is derived from two "simple" tables
with related data.
When I run the code in Access it works fine but not from VB. I downloaded
and installed the latest MDAC but it didn't help.
When I do "Select query" without (inner)join on either table I get the right
result...
Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
boolean fields... Does boolean datatype pose any kind of challenge in
constructing ADO queries?
Dim sSQL as string
sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
tbl_CashierLogInOut.Close = False
Connection...
Dim cnnStr As String, sPath as string
Dim cN As New ADODB.Connection
Dim RsAR As New ADODB.Recordset
'Set Connection String and connect to DB
sPath = "c:\Database\PS\MainDb.mdb"
cN.CursorLocation = adUseClient
cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
cN.Open cnnStr
RsAR.Open sSQL, cN ' Open Read only recordset
'''Code bombs out here...
please help
Thanks in advance
| |
|
| Access is a toy. You should be using SQL Server MSDE or Express Edition.
"JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
>I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a
>long
> time and want to move the code to
> ADO... I get a clueless error "-2147467259 Automation error - Unspecified
> Error" when I run this code. The code is derived from two "simple" tables
> with related data.
>
> When I run the code in Access it works fine but not from VB. I downloaded
> and installed the latest MDAC but it didn't help.
>
> When I do "Select query" without (inner)join on either table I get the
> right
> result...
> Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
> boolean fields... Does boolean datatype pose any kind of challenge in
> constructing ADO queries?
>
>
> Dim sSQL as string
>
> sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
> tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
> tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
> tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
> FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
> tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
> tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
> tbl_CashierLogInOut.Close = False
>
> Connection...
> Dim cnnStr As String, sPath as string
> Dim cN As New ADODB.Connection
> Dim RsAR As New ADODB.Recordset
> 'Set Connection String and connect to DB
> sPath = "c:\Database\PS\MainDb.mdb"
> cN.CursorLocation = adUseClient
> cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
> cN.Open cnnStr
> RsAR.Open sSQL, cN ' Open Read only recordset
> '''Code bombs out here...
> please help
>
>
> Thanks in advance
>
>
| |
| Dan Reber 2006-02-23, 6:55 pm |
| Not sure about Access but in SQL Server True is 1 and False is 0. Try
Dim sSQL as string
sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = 1 AND
tbl_CashierLogInOut.Close = 0
Dan Reber
"JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
>I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a
>long
> time and want to move the code to
> ADO... I get a clueless error "-2147467259 Automation error - Unspecified
> Error" when I run this code. The code is derived from two "simple" tables
> with related data.
>
> When I run the code in Access it works fine but not from VB. I downloaded
> and installed the latest MDAC but it didn't help.
>
> When I do "Select query" without (inner)join on either table I get the
> right
> result...
> Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
> boolean fields... Does boolean datatype pose any kind of challenge in
> constructing ADO queries?
>
>
> Dim sSQL as string
>
> sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
> tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
> tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
> tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
> FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
> tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
> tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
> tbl_CashierLogInOut.Close = False
>
> Connection...
> Dim cnnStr As String, sPath as string
> Dim cN As New ADODB.Connection
> Dim RsAR As New ADODB.Recordset
> 'Set Connection String and connect to DB
> sPath = "c:\Database\PS\MainDb.mdb"
> cN.CursorLocation = adUseClient
> cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
> cN.Open cnnStr
> RsAR.Open sSQL, cN ' Open Read only recordset
> '''Code bombs out here...
> please help
>
>
> Thanks in advance
>
>
| |
| JP Bless 2006-02-23, 6:55 pm |
| Thanks JT... Well that's why I am moving the code to ADO so I can use SQL
database etc.. But I am stuck right now... I am suspecting the real problem
is True/False datatype.
"JT" <someone@microsoft.com> wrote in message
news:OSHeoYKOGHA.532@TK2MSFTNGP15.phx.gbl...
> Access is a toy. You should be using SQL Server MSDE or Express Edition.
>
> "JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
> news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
Unspecified[color=darkred]
tables[color=darkred]
downloaded[color=darkred]
are[color=darkred]
tbl_Employees.LastName[color=darkred]
>
>
| |
| JP Bless 2006-02-23, 6:55 pm |
| Thanks Dan. I already tried 1 for True and 0 for false... but I didn't
work... Shouldn't ADO translate datatypes of different databases it is
connecting to? Well still stuck... Thanks
"Dan Reber" <dreber@nospam.com> wrote in message
news:et3PmiKOGHA.3576@TK2MSFTNGP15.phx.gbl...
> Not sure about Access but in SQL Server True is 1 and False is 0. Try
>
> Dim sSQL as string
>
> sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
> tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
> tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
> tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
> FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
> tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
> tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = 1 AND
> tbl_CashierLogInOut.Close = 0
>
> Dan Reber
>
>
> "JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
> news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
Unspecified[color=darkred]
tables[color=darkred]
downloaded[color=darkred]
are[color=darkred]
tbl_Employees.LastName[color=darkred]
>
>
| |
| Douglas Marquardt 2006-02-23, 6:55 pm |
| Hi JP:
I suspect the True/False issue as well.
Perhaps try this:
tbl_CashierLogInOut.Open <> 0
or...
tbl_CashierLogInOut.Open = 0
hth,
Doug.
"JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message news:O5xdziKOGHA.1288@TK2MSFTNGP09.phx.gbl...
> Thanks JT... Well that's why I am moving the code to ADO so I can use SQL
> database etc.. But I am stuck right now... I am suspecting the real problem
> is True/False datatype.
>
> "JT" <someone@microsoft.com> wrote in message
> news:OSHeoYKOGHA.532@TK2MSFTNGP15.phx.gbl...
> Unspecified
> tables
> downloaded
> are
> tbl_Employees.LastName
>
>
| |
| Norman Yuan 2006-02-23, 6:55 pm |
| Your code looks OK to me. It is most likely caused by your "SELECT...FROM
WHERE..." statement.
So, why don't you simplify your "SELECT..." stahement and add more detailed
version gradually to debug the code?
You can start with a simple
"SELECT * FROM tblMyTable"
Then join the other tables one by one, then add WHERE clause...
"JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
>I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a
>long
> time and want to move the code to
> ADO... I get a clueless error "-2147467259 Automation error - Unspecified
> Error" when I run this code. The code is derived from two "simple" tables
> with related data.
>
> When I run the code in Access it works fine but not from VB. I downloaded
> and installed the latest MDAC but it didn't help.
>
> When I do "Select query" without (inner)join on either table I get the
> right
> result...
> Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
> boolean fields... Does boolean datatype pose any kind of challenge in
> constructing ADO queries?
>
>
> Dim sSQL as string
>
> sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
> tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
> tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
> tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
> FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
> tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
> tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
> tbl_CashierLogInOut.Close = False
>
> Connection...
> Dim cnnStr As String, sPath as string
> Dim cN As New ADODB.Connection
> Dim RsAR As New ADODB.Recordset
> 'Set Connection String and connect to DB
> sPath = "c:\Database\PS\MainDb.mdb"
> cN.CursorLocation = adUseClient
> cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
> cN.Open cnnStr
> RsAR.Open sSQL, cN ' Open Read only recordset
> '''Code bombs out here...
> please help
>
>
> Thanks in advance
>
>
| |
| JP Bless 2006-02-23, 6:55 pm |
| Thanks norman... I did simplify the select statement... Now I figure the SQL
works if I exclude "AND tbl_CashierLogInOut.Open = True AND
tbl_CashierLogInOut.Close = False" So I think the problem has something to
do with specifying criteria for two boolean fields. Pain!
"Norman Yuan" <NotReal@NotReal.not> wrote in message
news:e$xQDFLOGHA.2992@tk2msftngp13.phx.gbl...
> Your code looks OK to me. It is most likely caused by your "SELECT...FROM
> WHERE..." statement.
> So, why don't you simplify your "SELECT..." stahement and add more
detailed
> version gradually to debug the code?
>
> You can start with a simple
>
> "SELECT * FROM tblMyTable"
>
> Then join the other tables one by one, then add WHERE clause...
>
> "JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
> news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
Unspecified[color=darkred]
tables[color=darkred]
downloaded[color=darkred]
are[color=darkred]
tbl_Employees.LastName[color=darkred]
>
>
| |
| F_clef 2006-02-23, 6:55 pm |
| JP
It's been awhile... but I remember (back in my Access days) getting a
similar error and it being attributed to the nulls in the boolean fields.
Access dbs allow nulls for these types of fields, but SQL Server does not.
Make sure those boolean fields are either TRUE/FALSE (1/0), and sorry I could
not find the web article to support the fix for this issue -- if it is the
same issue.
Hope that helps.
"JP Bless" wrote:
> Thanks norman... I did simplify the select statement... Now I figure the SQL
> works if I exclude "AND tbl_CashierLogInOut.Open = True AND
> tbl_CashierLogInOut.Close = False" So I think the problem has something to
> do with specifying criteria for two boolean fields. Pain!
>
> "Norman Yuan" <NotReal@NotReal.not> wrote in message
> news:e$xQDFLOGHA.2992@tk2msftngp13.phx.gbl...
> detailed
> Unspecified
> tables
> downloaded
> are
> tbl_Employees.LastName
>
>
>
| |
|
| I think your problem is in the naming of your fields.
What I can reproduce you can't use Open or Close as field names if you
want to execute SQL from VB-code. Executed direct from Visual Data
Manager it works, executed using ADO it fails.
If I'm correct changing Open to something like OpenCash and the same
for Close should solve your problem.
On Thu, 23 Feb 2006 12:42:46 -0500, "JP Bless"
<jp3BlessNoSpam@hotmail.com> wrote:
>I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a long
>time and want to move the code to
>ADO... I get a clueless error "-2147467259 Automation error - Unspecified
>Error" when I run this code. The code is derived from two "simple" tables
>with related data.
>
>When I run the code in Access it works fine but not from VB. I downloaded
>and installed the latest MDAC but it didn't help.
>
>When I do "Select query" without (inner)join on either table I get the right
>result...
>Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
>boolean fields... Does boolean datatype pose any kind of challenge in
>constructing ADO queries?
>
>
>Dim sSQL as string
>
>sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
>tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
>tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
>tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
>FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
>tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
>tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
>tbl_CashierLogInOut.Close = False
>
>Connection...
>Dim cnnStr As String, sPath as string
>Dim cN As New ADODB.Connection
>Dim RsAR As New ADODB.Recordset
> 'Set Connection String and connect to DB
> sPath = "c:\Database\PS\MainDb.mdb"
> cN.CursorLocation = adUseClient
> cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
> cN.Open cnnStr
> RsAR.Open sSQL, cN ' Open Read only recordset
>'''Code bombs out here...
>please help
>
>
>Thanks in advance
>
--
To reply by mail remove NEWS from my emailadres.
| |
|
| The SQL Server bit type does allow NULL.
"F_clef" <F_clef@discussions.microsoft.com> wrote in message
news:EBED951D-396D-4B2D-B8DD-35A319CB2185@microsoft.com...[color=darkred]
> JP
>
> It's been awhile... but I remember (back in my Access days) getting a
> similar error and it being attributed to the nulls in the boolean fields.
> Access dbs allow nulls for these types of fields, but SQL Server does not.
> Make sure those boolean fields are either TRUE/FALSE (1/0), and sorry I
> could
> not find the web article to support the fix for this issue -- if it is the
> same issue.
>
> Hope that helps.
>
> "JP Bless" wrote:
>
| |
|
| There is no boolean data type in SQL Server. Confirm that whatever data type
you are treating as boolean has only a range of 0, 1, or NULL.
"JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
>I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a
>long
> time and want to move the code to
> ADO... I get a clueless error "-2147467259 Automation error - Unspecified
> Error" when I run this code. The code is derived from two "simple" tables
> with related data.
>
> When I run the code in Access it works fine but not from VB. I downloaded
> and installed the latest MDAC but it didn't help.
>
> When I do "Select query" without (inner)join on either table I get the
> right
> result...
> Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
> boolean fields... Does boolean datatype pose any kind of challenge in
> constructing ADO queries?
>
>
> Dim sSQL as string
>
> sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
> tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
> tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
> tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
> FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
> tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
> tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
> tbl_CashierLogInOut.Close = False
>
> Connection...
> Dim cnnStr As String, sPath as string
> Dim cN As New ADODB.Connection
> Dim RsAR As New ADODB.Recordset
> 'Set Connection String and connect to DB
> sPath = "c:\Database\PS\MainDb.mdb"
> cN.CursorLocation = adUseClient
> cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
> cN.Open cnnStr
> RsAR.Open sSQL, cN ' Open Read only recordset
> '''Code bombs out here...
> please help
>
>
> Thanks in advance
>
>
| |
| JP Bless 2006-02-23, 6:55 pm |
| Super!!! fixed the problem... I changed Open to DOpen and Close to DClose
both in Access and SQL and it worked. I had the code running OK for years
using DAO but had no idea same would be a a problem in ADO... Thanks Jacob
and those who helped!!!
"Jacob" <jkheNEWS@planet.nl> wrote in message
news:bj9sv11u5kravvcth97snssokso008sef3@
4ax.com...
> I think your problem is in the naming of your fields.
> What I can reproduce you can't use Open or Close as field names if you
> want to execute SQL from VB-code. Executed direct from Visual Data
> Manager it works, executed using ADO it fails.
> If I'm correct changing Open to something like OpenCash and the same
> for Close should solve your problem.
>
>
> On Thu, 23 Feb 2006 12:42:46 -0500, "JP Bless"
> <jp3BlessNoSpam@hotmail.com> wrote:
>
long[color=darkred]
right[color=darkred]
are[color=darkred]
tbl_Employees.LastName[color=darkred]
> --
> To reply by mail remove NEWS from my emailadres.
| |
| JP Bless 2006-02-23, 6:56 pm |
| >I think your problem is in the naming of your fields.
>What I can reproduce you can't use Open or Close as field names if you
>want to execute SQL from VB-code. Executed direct from Visual Data
>Manager it works, executed using ADO it fails.
>If I'm correct changing Open to something like OpenCash and the same
>for Close should solve your problem.
>Jacob
Super!!! fixed the problem... I changed Open to DOpen and Close to DClose
both in Access and my app SQL and it worked. I had the code running OK for
years using DAO but had no idea same would be a problem in ADO... Thanks
Jacob and all (JT, Doug, Norman, F_clef) who helped!!!
"JP Bless" <jp3BlessNoSpam@hotmail.com> wrote in message
news:%23MPgcCKOGHA.2064@TK2MSFTNGP09.phx.gbl...
> I am using VB6/SP5 MDAC 2.8 SP1... I had this code running on DAO for a
long
> time and want to move the code to
> ADO... I get a clueless error "-2147467259 Automation error - Unspecified
> Error" when I run this code. The code is derived from two "simple" tables
> with related data.
>
> When I run the code in Access it works fine but not from VB. I downloaded
> and installed the latest MDAC but it didn't help.
>
> When I do "Select query" without (inner)join on either table I get the
right
> result...
> Please note (tbl_CashierLogInOut.Open) AND (tbl_CashierLogInOut.Close) are
> boolean fields... Does boolean datatype pose any kind of challenge in
> constructing ADO queries?
>
>
> Dim sSQL as string
>
> sSQL = "SELECT tbl_CashierLogInOut.CashierSessNum,
> tbl_CashierLogInOut.Terminal, tbl_CashierLogInOut.TranDayNum,
> tbl_CashierLogInOut.Cashier, tbl_CashierLogInOut.Open,
> tbl_CashierLogInOut.Close, tbl_Employees.FirstName, tbl_Employees.LastName
> FROM tbl_CashierLogInOut INNER JOIN tbl_Employees ON
> tbl_CashierLogInOut.Cashier = tbl_Employees.EmployeeNumber WHERE
> tbl_CashierLogInOut.Terminal='1' AND tbl_CashierLogInOut.Open = True AND
> tbl_CashierLogInOut.Close = False
>
> Connection...
> Dim cnnStr As String, sPath as string
> Dim cN As New ADODB.Connection
> Dim RsAR As New ADODB.Recordset
> 'Set Connection String and connect to DB
> sPath = "c:\Database\PS\MainDb.mdb"
> cN.CursorLocation = adUseClient
> cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath
> cN.Open cnnStr
> RsAR.Open sSQL, cN ' Open Read only recordset
> '''Code bombs out here...
> please help
>
>
> Thanks in advance
>
>
| |
|
|
|
|
| JP Bless 2006-02-24, 7:55 am |
| Worked too... wow... Thanks ML
Just wondering is there any where I can find other keywords ADO "barks at"
when used in SQL?
Thanks
"ML" <ML@discussions.microsoft.com> wrote in message
news:18F4C22A-1611-4E3C-8AD0-08DD0BF0B49D@microsoft.com...
> How about simply enclosing column names in brackets [Close], [Open] ?
>
>
> ML
>
> ---
> http://milambda.blogspot.com/
| |
|
|
|
|
|
|
|
| The smaller a data type is, then the more subjective. For example, there are
many shades of red ...
"ML" <ML@discussions.microsoft.com> wrote in message
news:1238674A-EB6F-4B6D-BF09-FDCE8AFA667E@microsoft.com...
> As does real life.
>
> "Was the car red? Yes or no!"
> "Don't know."
>
>
> ML
>
> ---
> http://milambda.blogspot.com/
| |
|
| Many shades of red? Not to me. ;)
But I do agree. Which still leaves room for the "don't know" or "not
important" or "not available" or NULL.
ML
---
http://milambda.blogspot.com/
|
|
|
|
|