Closed GoogleCodeExporter closed 9 years ago
I also tried (for the sake of completeness)
where (c.SomeOtherVal == "TRUE")
where (c.SomeOtherVal == "True")
where (c.SomeOtherVal.ToUpper().Equals("TRUE") == true)
Which all result in a "Sequence contains no elements"
When I tried
where (c.SomeOtherVal.Equals("TRUE") == true)
It gives a different problem, which I really don't understand.
'TRUE' is not a valid column name. Valid column names are: 'Serial_Number',
'SomeVal', 'SomeOtherVal'
Original comment by steven.v...@gmail.com
on 30 Mar 2011 at 1:13
Steve, can you attach an example spreadsheet that is experiencing this issue.
It will help me research the issue.
Original comment by paulyo...@gmail.com
on 1 Apr 2011 at 9:48
Paul,
File attached. Please let me know if there's anything else you need from me.
~Steve
Original comment by steven.v...@gmail.com
on 4 Apr 2011 at 1:31
Attachments:
Turns out that the Jet Database engine automatically converts "TRUE" and
"FALSE" strings to boolean.
All you should have to do is update the SomeVal and SomeOtherValue properties
to be bool rather than strings. And here is how your new query would look:
var testQuery2 = from c in excel.Worksheet<TestSetting>("Test2")
where (c.SomeOtherVal == true)
select c;
Original comment by paulyo...@gmail.com
on 23 May 2011 at 3:51
Original issue reported on code.google.com by
steven.v...@gmail.com
on 30 Mar 2011 at 1:07