You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, download files, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact contact us.
Isn't it cool the amount of powerful tasks you can complete from that little Pocket PC you've been carrying around in your pocket? :mrgreen: Now Jean-Luc David has written a tutorial about how you can Maintain your Web site data on your Pocket PC using SQL Server CE over at Builder.com.
Personally, I have a love/hate relationship with SQL CE. I love the speed and the power, but I hate the wordiness of the commands used to extract and insert data. Once there's a problem with a join or something it takes me a long time to fix. Still, the power and speed makes it all worth it. Unlike other replication methods, Remote Data Access uses queries launched from Windows CE to transfer data from a remote server to the handheld and vice versa. The SQL CE Query Analyzer is a useful tool to manipulate the database using queries. The Objects browser, shown in Figure E, allows you to change the structure of the local database (for example, you can add and remove tables, columns, and fields)
Any SQL newbies or gurus in our midst who would like to comment?
Linear Mode
