Limitations Of SqlServerCE...:-(

  • Thread starter Thread starter Zahid
  • Start date Start date
Z

Zahid

Hi,

I read from the MSDN Library July 2003 Edition:
----------------------------------------------------
No support for batch queries. Queries must be a single
SQL statement. For example, the following statement is
valid:
SELECT * FROM Customers

This statement is not valid:

SELECT * FROM Customers; SELECT * FROM Customers2

No support for named parameters.
-----------------------------------------------------

When will these features be available? Are there any
workarounds/alternatives? Im relying quite heavily on my
SQLServerCE database as its core to my application.

Thanks in advance.
 
Hi,

Ive got the query:

mc.CommandText = "Select Description from ListHdrs where
ListHdrs.description = sweets"

where description is a field in the ListHdrs table. I get
an error message showing - Native error (25503)
"The column name is not valid" ...
Why? description is a valid column name?

Is this the same limitation i mentioned in the above
message?

Thanks in advance.
 
If memory serves (but could be wrong) I didn't think SQLCE supported
referencing fields in queries in that way - just lose the '<tablename>.'
 
Try this one:

Select "Description" from ListHdrs where "Description"
= 'sweets'

The trick is to use double quotes to denote column and
table names.
 
Hi,

I tried using "description" but it still doesnt work. It
gives me the error:

" The Column name is not valid. [,,Node name (if any),
Column name,] "

What does this error mean and how do i fix it?
Its urgent....

Thanks in advance.
 
That is what I perceive to be a generic SQLCE message - unhelpfull.

Try doing a basic select query without the WHERE clause. Also, I assume
the 'Description' field is text, so you'd need to enclosesweets in
single quotes:

Simple Query:
SELECT Description FROM ListHdrs

Query with clause:
SELECT Description FROM ListHdrs WHERE Description = 'sweets'

Appologies if you know this already, but better to explain things all
the way, than possibly leave you uncertain.


Paul

Hi,

I tried using "description" but it still doesnt work. It
gives me the error:

" The Column name is not valid. [,,Node name (if any),
Column name,] "

What does this error mean and how do i fix it?
Its urgent....

Thanks in advance.


-----Original Message-----
If memory serves (but could be wrong) I didn't think
Click to expand...

SQLCE supported
referencing fields in queries in that way - just lose
Click to expand...

the ' said:
Zahid wrote:


where

get


.
Click to expand...
Click to expand...
 
Thanks,

I did exactly as you advised and it worked. Thanks.

Just out of interest.... are you using C# to create your
pocket PC app? Im using VB.Net and my app runs quite
slow and takes up a lot of memmory but i cant see why. I
heard C# apps run faster and take up less memory compare
to VB.NEt?

Thanks in advance.
-----Original Message-----
That is what I perceive to be a generic SQLCE message - unhelpfull.

Try doing a basic select query without the WHERE clause. Also, I assume
the 'Description' field is text, so you'd need to enclosesweets in
single quotes:

Simple Query:
SELECT Description FROM ListHdrs

Query with clause:
SELECT Description FROM ListHdrs WHERE Description = 'sweets'

Appologies if you know this already, but better to explain things all
the way, than possibly leave you uncertain.


Paul

Hi,

I tried using "description" but it still doesnt work. It
gives me the error:

" The Column name is not valid. [,,Node name (if any),
Column name,] "

What does this error mean and how do i fix it?
Its urgent....

Thanks in advance.


-----Original Message-----
If memory serves (but could be wrong) I didn't think
Click to expand...

SQLCE supported
referencing fields in queries in that way - just lose
Click to expand...

the ' said:
Zahid wrote:


Hi,

Ive got the query:

mc.CommandText = "Select Description from ListHdrs
where

ListHdrs.description = sweets"

where description is a field in the ListHdrs table. I
get

an error message showing - Native error (25503)
"The column name is not valid" ...
Why? description is a valid column name?

Is this the same limitation i mentioned in the above
message?

Thanks in advance.


-----Original Message-----
Hi,

I read from the MSDN Library July 2003 Edition:
----------------------------------------------------
No support for batch queries. Queries must be a single
SQL statement. For example, the following statement is
valid:
SELECT * FROM Customers

This statement is not valid:

SELECT * FROM Customers; SELECT * FROM Customers2

No support for named parameters.
-----------------------------------------------------

When will these features be available? Are there any
workarounds/alternatives? Im relying quite heavily on

my


SQLServerCE database as its core to my application.

Thanks in advance.
.


.
Click to expand...
Click to expand...

.
Click to expand...
 
I believe it is, when the column or table name happens to be a restricted
word
(eg. "PrimaryKey")
 
Back
Top