Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Windows Mobile CE
I have windows application to synchronize Sql CE database data of a windows mobile application. I got few issues on synchronization of mobile connected to windows 7 32bit PC.
 
On synchronization, windows application will copy Sql CE databse from Mobile Device to the PC and do synchronization of data with locally coppied database then copy back to the Mobile Device. If the PC which done synchronization is a windows 7 32Bit then I'll get following issues in Windows Mobile Application when working with synchronized database.
 
If there is a table with nVarChar column and do search query on that column, No data will return if search condition contain numerals with single quotes to indicate value as a string (In following example strProductID is a nVarchar column)
 
eg:-
SELECT * FROM Products WHERE strProductID='2345'
 
But numerals without quotes or alpha with quotes will works fine
 
eg:-
SELECT * FROM Products WHERE strProductID=2345
 
or
SELECT * FROM Products WHERE strProductID='asdasd'
Posted 16-Apr-13 21:38pm
Edited 16-Apr-13 22:46pm
v6

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try this
SELECT * FROM Products WHERE strProductID = N'2345'
Happy Coding!
Smile | :)
  Permalink  
Comments
milinda saranga at 17-Apr-13 3:38am
   
I have a mobile application which already diployed and it works fine on synchronization of mobile connected with XP or Windows 7 64bit PC but only with Windows 7 32bit i will get this issue. I need to find is there any solution without doing changes to application code such as changing configurations of the windows environment wich done synchronization or any such solution.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 17 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100