Hello All,

I wish to prepare one query that should be based on some IF-ELSE
conditions in SqlCe.

The situation is like i have 2 radio buttons, and a search textbox.
And i want to search the data based on the search textbox input and
the radio button selected.

Please give some clue on how to execute block statements in sqlce.

Thanks n Regards
Vikash

hai...

Am using sql server ce2.0 in my target device.. and i would like to
copy my database table to other database... by using the following
query but it doesn't work..(following code embedded with evc++ &
wince platform)

" create table table2 like db1.table1;
"insert into table2 select * from db1.table1;

sql server ce2.0 support this query..?. it display the error message
always... plz help if anyone have an idea about how to copy the table
from one database to an other database...it would be fine...

I am having trouble with SQL Server Compact Edition 3.1 on windows CE 5 on a
PAXAR Monach Pathfinder Ultra 6039 device.

After I have installed it and then try and do this :

Dim CeEngine As SqlCeEngine
Dim ConnString As String = "\mydatabase.sdf"
CeEngine = New SqlCeEngine("Data Source = " & ConnString) <-- error is
thrown on this line!
CeEngine.CreateDatabase()

I get the following error :

can't find pinvoke dll 'sqlceme30.dll'

Running the same code on another windows ce 5 device works fine.

I have manually installed the following cab files into the default
installation directory i.e \windows :

sqlce30.wce5.armv4i.CAB
sqlce30.repl.wce5.armv4i.CAB
sqlce30.dev.ENU.wce5.armv4i.CAB

These install without a problem and are listed in the add/remove programs.

I have noticed a couple of other things.

I am having problems using SQL CE 3.5 on CE6, not finding a lot of
information on compatibility only one blog posting I found said SQL CE 3.5
"will be" compatible with CE6.

Any help will be greatly appreciated.

Regards,

Brian K. Williams

Ciao, a tutti quelli come me che vivono nella Provincia di Roma, ho trovato
due siti dove sono inserite tutte le case a Tivoli, le case a Guidonia, a
Villanova, a Settecamini, le case a Setteville, case a Castel Madama, a
Vicovaro, a Marcellina, a Palombara, a Rocca Santo Stefano, le case a
Monterotondo e molte altre città di questa zona. Inoltre ho visto che su
molti immobili sono presenti anche delle visite virtuali e praticamente è
possibile navegare all'interno delle abitazioni. i Siti sono
http://www.caseativoli.it oppure su http://www.casedavedere.it

My app is a .NET CF 2.0
I m working with SQL Server CE 3.5

I can read data in my database but write or delete operations raise no
exception but they dont have any influence on the database...

where can be the problem ? any clue ?

hi,
We have developed applications on the wince 4.2 using SQL CE 2.0.
Now we wanna transfer the sqlce to 3.0 edition but dont wana update
the wince to 5.0.

From the internet I got some information which tell me it would get
some truble of this progress and I have tried many times and failed!

Does anybody have experience on this work?

Please give me your help.

Thank you all.

Using VS2005
Sqlce 3.1
I have changed the dataset designer to generate ResultSets. The
generated code seems to open the table with no ability to select the
items i want. I want to select a subset within the tables (Select *
from Item where prodline = "foo") .I have tried creating a partial
class but i cant seem to get it to work. Below is an example

Env.: SqlCE 3.5, Windows Mobile 6

Hi All,

I use .xsd based strongly typed data sets to access my DB.
Is it possible to retrieve @@identity from an Insert method?

TIA,

Serge.

Hi,

I'm evaluating sqlserver compact and I have detected an ugly
restriction.
Apparently, its not possible to create a table containing 'double
precision' values, like

Create Table myTab (myDbl DOUBLE PRECISION);

The result is:
SQL Execution Error.
Executed SQL statement: Create Table myTab (myDbl DOUBLE PRECISION);
Error Source: SQL Server Compact ADO.NET Data Provider
Error Message: There was an error parsing the query. [ Token line
numer = 1, Token line offset = 27, Tiken in error = DOUBLE ]

While spending some time with the problem, I have found MS
documentations that claims double precision is a valid data type for
sqlserver compact. This is also what I expect from a database system.

I got the sqlserver compact 3.5 by installing VS 2008. I also ran an
update to the latest runtime version, but this seems to have changed
nothing.