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!
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:
2 2
1 1
0 0
3 3
Or like this:
2 0
1 1
0 2
3 3
|||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
No comments:
Post a Comment