Re: I need help with my SQL Statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Jan 21, 6:58 pm, Jin <jinsooch...@xxxxxxxxx> wrote:
On Jan 21, 5:08 pm, The Mad Ape <chief...@xxxxxxxxx> wrote:



Hi I am using sqlce on my desktop and trying to write a query that
sums two fields. I am an Access guy and built this query there. When I
tried to use it in my application it crashes

Dim sqlStands As New SqlCeCommand("SELECT si_stand, Sum(si_size) AS
TotSz, Sum(si_samplelength) AS TotLen FROM(tblStandInfo) GROUP BY
si_stand ORDER BY si_stand", MyConn)

Error reads as follows:

SQLCe Exception was unhandled

There was an error parsing the query. [ Token line number = 1,Token
line offset = 89,Token in error = ) ]

I do not see the error. Please help.

Thanks

The Mad Apewww.tatumba.com

I think removing the parenthesis from the source table name should do
the trick. You can use the [] to enclose the name, but not ().

- Jin


Hi again Jin

I think I may have discovered the problem. The fields that need summed
are character, not numeric, even though all values in the table are
numeric in nature.

I tried: Dim sqlStands As New SqlCeCommand("SELECT si_stand,
Sum(CDbl([si_size])) AS TotSz, Sum(CDbl([si_samplelength])) AS TotLen
FROM tblStandInfo GROUP BY si_stand ORDER BY si_stand", MyConn)

Although it works in Access it does not work in MS SQL. I will have to
look at the table creation and redo it unless you know of a way to
converting string to double numeric on the fly within MS SQL.

The error I am getting currently is:

The function is not recognized by SQL Server Compact Edition. [ Name
of function = CDbl,Data type (if known) = ]


The Mad Ape
www.tatumba.com
.