The following code produces an exception in SQL CE.

                CETestCollection coll = new CETestCollection();
                int n = coll.GetDbCount();

I get the exception:

An exception was caught duting the execute of a retrieval query: There was an error parsing the query. [ Token line number = 1, Token line offset = 39, Token in error = SELECT ]. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

Here is the sql it generated:

Query: SELECT COUNT(*) AS NumberOfRows FROM (SELECT \"CETest\".\"MyText\" FROM \"CETest\") TmpResult

My test table in SQL CE (CETest) has just a single field:

Column  DataType    Length  AllowNulls  Unique   PrimaryKey
MyText   ntext        16            Yes           No            No

Info:

SQL Compact Framework 2.0 SP1 LLBLGen Pro 2.0 Aug 3rd

Michael

Hi Michael
Can you please try to execute your SQL

SELECT COUNT(*) AS NumberOfRows FROM (SELECT \"CETest\".\"MyText\" FROM \"CETest\") TmpResult

.

Also, please paste the full stack dump

This is indeed a known issue, SqlCE limitation.

Please rewrite the query as a scalar query, thus write a GetScalar() call which emits something like: SELECT COUNT(*) FROM CETest.

I'll rewrite the DQE method.

The DQE for CE isn't as well tested as other DQE's because unittests are impossible on CE, so every testing is done manually with a testapp. I missed this method.

Will do, and thanks for the help. Yes, I can see where if you cannot run unit tests the CE libs would be difficult to have completely tested. I will try to post anything I see while working on this short Windows Mobile project (and if there is anything I can test for you, just let me know).

So far, everything else I have touched appears to work well.

[Edit] Since its a known issue I didn't add the stack trace, but if you anyone wants it I will gladly do so, just let me know.

Added an exception throw to the next build.