HI,

I'm doing the following in a CF SQLCE adapter project:

maxrow = Convert.ToInt16(adapter2.GetScalar(EntityFieldFactory.Create(TubeFieldIndex.TubeRow), AggregateFunction.Max));

i get error cannot error cannot convert from 'object' to 'bool'.

When i try the same in a normal windows application this works fine.

Anybody knows how to work around this ?

Thanx in advance.

Jan

jspruit wrote:

HI,

I'm doing the following in a CF SQLCE adapter project:

maxrow = Convert.ToInt16(adapter2.GetScalar(EntityFieldFactory.Create(TubeFieldIndex.TubeRow), AggregateFunction.Max));

i get error cannot error cannot convert from 'object' to 'bool'.

When i try the same in a normal windows application this works fine.

Anybody knows how to work around this ?

Thanx in advance.

Jan

Jan,

I don't know that I can answer your question with the information provided. What I do have are lots of questions for you...

Can you please post a more complete example?
What datatype is maxrow? I would assume it to be an integer. Does the line listed above throw the error?
Is the error on the convert or the GetScalar or the Create function? Can you provide the stack trace that accompanies the error?

Answering these questions for yourself may provide an answer. If not please post additional information and we will help you figure it out.

Additionally, if you do: object o = adapter2.GetScalar...

does that work? if so, what is the type of o?

Hi,

I discovered what the reason is.

Query executed:

SELECT TOP 1 MAX("tube"."tubeRow") as "TubeRow" from "tube"

I tried this in SQL server, this works fine.

When i try this in SQLCE it doesn't work because of "TOP 1"

When i remove "TOP 1" query works fine with same result

Don't know if this needs to be altered in LLBL template for SQLCE ???

Regards,

Jan

jspruit wrote:

Hi,

I discovered what the reason is.

Query executed:

SELECT TOP 1 MAX("tube"."tubeRow") as "TubeRow" from "tube"

I tried this in SQL server, this works fine.

When i try this in SQLCE it doesn't work because of "TOP 1"

When i remove "TOP 1" query works fine with same result

Don't know if this needs to be altered in LLBL template for SQLCE ???

Regards,

Jan

Good catch! I'll adjust the DQE for CE and will release a patch today. It appears 'TOP' isn't supported. I'll remove it from the query generator for CE. Strange that I didn't see that in the list of features not supported on CE.

Thanks for the fast support !!

Regards,

Jan

It's available