index > SQL Server Everywhere Edition > Can it be a bug in SQL CE?

Can it be a bug in SQL CE?

Hi!

I use SQL CE with VS.NET 2003. I find the following bug second time.

The table has an "ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity.

I add rows to the table, then I made some select and update queries. Then I realized that the ID order not in the general order (from 0 to ........)

For example: 6,7,8,0,1,2,3,4,5.

Of course row 6,7 and 8 was added the very last.

The content of each row is not mixed, only the ID order.

Is it a very confused, because we develop mobile invoice programs for PDAs.

What I did wrong?

Thank you!

jaczura

Do you mean rows are not sorted by ID should you retrieve them with select or IDs are created not in order of insertions? Say, you have integer column in addition to ID, and you've inserted numbers from 0 to 3 into it. Do you get data like this:

Ilya Tumanov

Duplicate thread from the same user: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=229153&SiteID=1

Follow only the above given thread. This thread will not be monitored any more.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

Please hit "Yes", if my post answered your question(s). All postings are as-is and confer no rights.

Laxmi NRO MSFT

reply 3

You can use google to search for other answers

More Articles

• How solid is Sql Server Everywhere?

• Determining if a SqlCeDataReader has returned data from a SELECT ...

• Error While Installing SQLServer CE

• SQL Everywhere ConnectionString problems

• RAPI fails on CeMountDBVol (WinMobile 5)

• SQL Server CE problem

• parameterized query that counts the number of null values in an i...

• SqlCeResultSet - Problem After Deleting First Record

• HELP US MICROSOFT: SYNCH BETWEEN SQL EXPRESS AND SQL MOBILE

• What does it take to update a SQL Everywhere db?

Welcome to Bokebb New Update

New Articles

• Loading data in SQL Mobile 2005 from the
• Why EDB can't accept two properties with
• connecting to sql server from mobile dev
• RDA pull problem
• access SQL2005 MOBILE database in a VS20
• Smart Client - Data Centric - SQL 2K to
• VS 2005 - VB.NET - Connect to mobile SQL
• Strange Problem: .sdf 128MB filesize limit
• GUIDs using NEWSEQUENTIALID() on SQL Ser
• How do I automatically populate new rows
• GUID in Mobile SQL
• Upgrade SQLServer Mobile (.sdf) database
• Windows Mobile 5 connecting to SQL Serve
• Sql Server CE 2.0 Proxy Replication Scen
• SqlCe Memory issue

Hot Articles

• SQL Mobile Installation Problem on Device
• SQL 2005 Mobile vs .NET CF 2.0 SP1?
• Replication Error
• .Net CF 2.0 Error , "Can't find PIn
• Connection string for SqlCeConnection
• operating system does not support encryp
• Newbie: Am I really using Everywhere?
• Merge Replication IIS Worker Process Error
• Subset of TSQL supported by SQL Server m
• Any Movement on the 4 gig limit???
• SQL Mobile Embedded XP support?
• any one know whats wrong with it
• Getting started with SQL Server Mobile
• Connection String Encryption for SQL Ser
• SQL CE Merge Replication

Recommend Articles

• Error when "SELECT" statement
• Cannot get RDA.Pull to work
• Cannot save English dates!
• SQL Server Mobile and isqlw20
• Transform??sql server mobile edition dat
• genral network error on .net framework 1
• duplicated data display
• SQL Server Everywhere - Retrieve Identit
• How do I automatically populate new rows
• Insert GUID into SQL Mobile Database tab
• Merge Replication with SQL Server 2000
• Connection to database takes up alot of
• Merge replication and SSL
• MDB to SDF
• SDK for SQL ev?