CODEWITHSUNDEEP
sql-server-cewindows-mobilecompact-frameworkwindows-mobile-6.5activesync
nullpointer
nullpointer

Reputation: 1

Windows XP SQL Server CE issue with INDEXING on Windows Mobile Embedded 7

This is our environment:

Here is what we are experiencing:

When attempting to apply an INDEX to any table of any .SDF file, it executes okay and applies the constraint. This Index can be done through code or through a database viewer such as sdfviewer. The issue is only evident when the .SDF has been sent to the X4 skorpio. What happens is, any column that has an INDEX constraint applied to it fails to return anything but a 0 when queries (i.e. SELECT * FROM Users WHERE [TheIndexedColumn] = 'Bananas' returns 0, Banana's exist but if you do 'SELECT * FROM Users', you get all the columns.).

Example: table Users

UserID (INT or BIGINT or NVARCHAR) – This is the primary key and also indexed
Firstname (NVARCHAR)
LastName (NVARCHAR)
...

Let’s say that this Users table has been populated with many users with first name and last names (unique users). If we were to query the UserID column, we get a result of 0. If the index is removed, we are able to apply many different queries successfully.

Opening the .SDF file using an sdf viewer shows no sign of corruption (from what we can see). On the Datalogic X4 device, the database is able to be opened and closed without any runtime errors.

Are there any scenarios where this issue doesn’t exist?

Please refer to this table to see where it works without fault

Troubleshooting findings so far:

  1. The .SDF (database file) behaves normally if being deployed (database opened and closed) from a Windows 7 environment
  2. The issue arises only between X4 Skorpio and Windows XP (database opened and closed within an XP machine)
  3. The issue is only evident when an Index is applied to any column in a table.
  4. The issue is not evident on columns that do not have an index.
  5. If we copy the .SDF file that has been kept on a Windows 7 machine to the Skorpio X4, the application behaves fine.

Any assistance would be highly appreciated as we have exhausted all options so far. Using Windows 7 is not an option :(

Upvotes: 0

Views: 161

Answers (0)

Related Questions