|
SprintDB Pro
General
SprintDB Pro
Desktop Companion
Database Synchronization
SprintDB Pro Forms and Controls
What is SprintDB Pro+Printing?
The SprintDB Pro+Printing Edition allows you to print
your tables and forms directly from your Pocket PC to
many supported printers via Infrared, Serial and
Bluetooth. You can also print barcodes in SprintDB
Pro+Printing. SprintDB Pro+Printing is identical to
SprintDB Pro standard (non-printing) version, except for
the
printing features.
Top
What is the SprintDB Pro Desktop
Companion?
The SprintDB Pro Desktop Companion allows you to develop
your SprintDB Pro Pocket PC applications on your Desktop
or Notebook PC. This provides the user with a
development environment which is far easier to use and
therefore allows you to create feature-rich applications
far more quickly than is possible on the limited screen
real estate of the Pocket PC. Of course there is nothing
preventing you from using the Desktop Companion to
create PC only database applications or applications
that you want to run on both platforms.
Top
How do I Install SprintDB
Pro databases created by other users?
SprintDB Pro and its Desktop Companion store your forms
and queries in a separate "Form" file with the ".raf"
extension, not in the database file itself (.cdb or .mdb).
Database applications created within
SprintDB Pro consists of two files, a database file (.cdb
or .mdb) and its form file (.raf).
The Database
files (.cdb) can be copied to any folder on your
Pocket PC (usually \My Documents). The Form files (.RAF)
should be copied into the SprintDB Pro Forms Folder.
(\Program Files\SprintDB Pro\Forms by default)
Top
How do I distribute my
SprintDB Pro applications?
-
Copy the
database file (*.cdb) to any folder on the user's
Pocket PC.
-
Copy the form
files (*.RAF) to the \Program Files\SprintDB Pro\Forms
directory.
Of course you
can also, create a ZIP file that includes a README.TXT
file, informing your users to do the above. Or create a
stand-alone installation .exe file that does it
automatically. Keep in mind that the user is
able to define a different "Forms Folder", if they so
desire.
Please note
you are not permitted to distribute the SprintDB Pro
application itself. Your
user needs their own registered copy of SprintDB Pro to run your
applications on their device.
Top
What is Pocket Access? Do
I need any other applications to run SprintDB Pro?
Pocket Access
is the database format that SprintDB Pro Pocket PC
version is based on. ActiveSync will convert your MS
Access databases (.mdb) to the Pocket Access files (.cdb)
format. You
don't need any other applications to run SprintDB Pro on
your Pocket PC. You can also create new Pocket Access
databases and tables by using SprintDB Pro on your
Pocket PC.
Top
Is SprintDB Pro compatible with
Windows Mobile 5.0/6.0?
SprintDB Pro
is fully compatible with Windows Mobile 5.0/6.0.
SprintDB Pro supports Pocket PC running Microsoft Windows CE
3.0 (Pocket PC 2000), Pocket PC 2002,
Windows Mobile 2003/2003SE, Windows Mobile
5.0, Windows Mobile 6.0.
Top
Does the SprintDB Pro package
include the Desktop Companion?
No. SprintDB Pro Desktop Companion is a separate
product. If you would like to use the full version of
the Desktop Companion, you need to purchase it
separately.
Top
Does SprintDB Pro Desktop Companion
work with Pocket Access files?
No. SprintDB Pro Desktop Companion only handles desktop
.mdb files. If
you have your database in Pocket Access (.cdb format) on
your Pocket PC, you need to convert it to Desktop
Access (.mdb) file using ActiveSync.
Top
What are the differences between
SprintDB Pro and its Desktop Companion?
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.
You can find more
information about the differences
here.
Top
I
have a SprintDB Pro application on my Pocket PC. How do
I move it and run it on my Desktop PC in the Desktop
Companion?
You need to convert your .cdb database to a .mdb
database by using ActiveSync, and then copy its Form
files to your Desktop PC.
For more information about how to import/export Forms,
click
here.
Top
What are SubForms?
SprintDB Pro is not a fully relational database like
Microsoft Access. Instead SprintDB Pro includes a powerful
SubForm feature to allow you to handle more than one table
on a single form.
A
SubForm is a collection
of controls that have an alternative record source that
can be related to the record source of the MainForm.
A SubForm
is a form within a form. The primary form is called the
Main Form, and the form within the form is called the
SubForm. A Form/SubForm
combination is often referred to as a hierarchical form,
a parent/child form. Sub forms are especially effective
when you want to show data from tables or queries with a
one-to-many-relationship. For these types of SubForms,
you should specify its record source properly to
synchronize it with its master form.
You can
also insert a SubForm which will not synchronize with
any Master form. This type of SubForm has no parent
form. You can specify its RecordSource in event
procedures by using the SetFormSource() macro action which
will be executed at run-time.
SubForm Exercise
Please follow the
instructions in the
Orders Tutorial.
Top
How can I set the text in an Edit
control to word wrap?
Set the Edit
control's AutoHScroll property to "No". It is
"Yes" by default.
To set th is
property,
-
Select
the Edit control in Form Edit mode.
-
Tap
Tools > Control Properties.
-
On the
Basic tab, scroll down to the AutoHScroll
property and set it to No.
Top
My ComboBox only displays a few
items when tapping the control's arrow button at
run-time.
Adjust the height of the ComboBox in
Form Edit mode by dragging its resizing handle(s).
Top
Are there any way to reference a particular column in
a
ComboBox's RowSource?
Unfortunately, it is not possible to
reference a particular column in a ComboBox.
&comboControl will always return the
currently selected Bound Column.
Top
Does the Control.Column() property work with a ComboBox?
The Control.Column() property will work
with a List Control, but not with a Combo Box.
&comboControl will always return the
currently selected Bound Column.
Top
I have been using
two
Combo
Boxes.
How do I populate the second
one
with values corresponding to the first
ComboBox?
To do this use the SetComboSource()
macro action in the AfterUpdate event of the
first ComboBox.
Example
Set the AfterUpdate event of the first
ComboBox to:
SetComboSource( &secondCombo,
"SELECT table2.field1 FROM table2 WHERE table2.field2=&firstCombo"
)
This will automatically update the
second ComboBox whenever you select an item from the
first ComboBox.
Top
How do I set the focus to a
specified tab in a Tab control?
You can
use the TabControl.FocusTab( tabPageIndex )
property to set the focus to a specific tab page.
Please
note the index of the Tab control starts with 1. (1 is
the first tab page, 2 is the second tab page, etc.)
Example
If(
&myCheck1=TRUE )
SetControl( &myTab1.FocusTab( 1 ) )
Else
SetControl( &myTab1.FocusTab( 2 ) )
EndIf
Top
Can I view SprintDB Pro
Scribbles in a Microsoft Access database?
SprintDB
Pro Scribbles are saved in the underlying OLE Object
field and are not compatible with Microsoft Access.
If you
would like to view the scribble in MS Access or other
applications on your Desktop PC, please save the
scribble as an external image file in .BMP or .JPG
format by using the SaveScribble() macro action.
SprintDB Pro OLE Object Scribbles on the Pocket PC are
fully compatible with the SprintDB Pro Desktop
Companion.
Top
|
