Overview These
differences are important when creating applications that will work with both the Pocket PC and Desktop versions. Differences in SQL Use
SprintDB Pro Pocket PC version uses ADOCE
(Microsoft ActiveX Data Objects for Windows CE) and the Desktop version uses
standard desktop ADO. Please
keep in mind that there are limitations in the SQL
statements that are supported by ADOCE versus standard
desktop ADO.
Please refer to the
Supported SQL statements section for more
information about the SQL statements that are
supported by ADOCE.
Date-Time Field Usage
To refer to a Date-Time field, you should enclose date time with [#], not ["] or ['] in the Desktop Companion.
For example:
SELECT * FROM table1 WHERE table1.datefield1="05/20/2003"
will not work on the Desktop version.This should be changed to:
SELECT * FROM table1 WHERE table1.datefield1=#05/20/2003#
This will also work with Pocket PC version.
To refer to a date-time in a SQL statement in forms, please use the to_date()
function
.
to_date() will append the # character automatically around the date-time, and this will allow you to run the form on both the Pocket PC and Desktop Companion.
For example:
In the OnClick
event of a button control
SetControl(SubForm1, "SELECT * FROM table2 WHERE table2.datefield1 = &datetimeControl1" )
This will not work on the desktop version.
Should be changed to:
SetControl(SubForm1, "SELECT * FROM table2 WHERE table2.datefield1 = to_date(&datetimeControl1)" )
This will work with both of Pocket PC and Desktop versions.Boolean Field Use
You can use 1 or -1 to test if a Boolean field is true in the Pocket PC version. But in
the Desktop version, you should use -1. 1 cannot be used to test if a Boolean field is TRUE.
It is recommended to use TRUE or FALSE, instead of -1, 0 or 1. These will work on both of Pocket PC and Desktop
versions.
For example:
SELECT * FROM table1 WHERE table1.boolean1=TRUE IS Usage
"IS" in an SQL statement that will not work on Desktop version.
For example:
SELECT * FROM table1 WHERE table1.boolean1 IS TRUE
will not work on the Desktop version.
The above should be changed to:
SELECT * FROM table1 WHERE table1.boolean1 = TRUE Comparison Operator
The "=" comparison operator will not work with a double type field on the PPC version.
If you wish to test if a double field equals to a specific value, you
need to use <= and >= together, instead of =.
For example:
SELECT * FROM table1 WHERE table1.doubleField1>=3.4 and table1.doubleField1<=3.4
Label Control Events
Events on
Label
controls are currently NOT supported in the Desktop Companion. You can only add or edit these events in SprintDB Pro 2.0 on the Pocket PC. Tab Control Differences
The
Old Style Tab
control on the Desktop Companion has a grey background (RGB 192,192,192) and 3D appearance. This color property cannot be changed.
<Top | Help Index>
|
