Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the differences between SprintDB Pro and its Desktop Companion?

April 26, 2017companion desktop differences sprintdb pro

0

Posted

What are the differences between SprintDB Pro and its Desktop Companion?

1 Answer

0

Posted

The SprintDB Pro Desktop Companion is based on standard Desktop ADO and works with .mdb databases while SprintDB Pro (Pocket PC version) is based on ADOCE (Microsoft ActiveX Data Objects for Windows CE) and works only with Pocket Access .cdb databases. The Pocket Access database engine is very limited when compared to the desktop database engine. So you need to use only SQL statements supported on the Pocket PC to create applications that run on both platforms. Some SQL statements that work without any problems on the Pocket PC could cause errors when running on the Desktop PC. For example, SELECT … WHERE table1.datafield1=’03/01/2004′ should work on the Pocket PC, but it’s not a valid statement on the Desktop Companion. Instead, you need to use SELECT … WHERE table1.datefield1=#03/01/2004#. This will work on both the Pocket PC and Desktop PC. For more information about the differences, please refer to the user manual.