SprintDB Pro 2.0 has been developed to work with the new Desktop Companion, allowing you to develop your applications on either or both platforms. A number of new features have also been added.

See also

• Using the Desktop Companion

• System Requirements 

• Differences between the Pocket PC and Desktop versions

A example application "_SDP_Orders20" comes with SprintDB Pro 2.0. It will show you how to work with the new features in Ver 2.0. For example, using modules, working with Pocket Outlook Contact database, etc. To open the sample application, tap Help > Sample Database.

Changes to the Menu Layout

The Menu layout in the new version of SprintDB Pro has been updated to make it easier to use. 

The new menu arrangement is shown below.

Changes to the User Interface

The Properties Button

A new Properties button has been added to the menu panel in the Form Edit view. You can now set the properties of a selected control by selecting the control first and then tapping the Properties button.

Control Alignment Grid

You can now display the Control Alignment Grid in the Form Edit view. The width and height and grid color can be altered by selecting File > Options.... You can also switch off the grid.

Modules

Supports new code Module. The new Code Module allows you to create applications with great flexibility. Modules are similar to Form Macros, but Modules are available to all the forms in a database. You can use Modules to save macros and call them from any form.

• The SprintDB Pro Main Form (below) now has a new Tab, titled "Module". 
• To create a module, tap the New button on the Module tab-page on the main screen.
• To call a module in a macro/script, use the CallModule() macro command.
• You can pass a maximum of 10 parameters to a module. The parameters should be variables (local or global).
• In a module, you can access (read/write) the parameters by using the @@paramN notation.
• There's no limitation on the number of modules in a database.

Example

Calling a module in a form:

Dim(var1)
Dim(var2)
SetVar(@var1, 1)
CallModule(myModule1, @var1, @var2 )
MsgBox(@var2)

MyModule1:
MsgBox(@@param1)
SetVar(@@param2,"hello from module1")

Database Encryption

Supports Encrypt/Decrypt Database in SprintDB Pro 2.0 for the Pocket PC.

You can now encrypt Pocket Access (.cdb) database files. Database encryption is useful when you are concerned about unauthorised access to your valuable data. 

• Tap Tools > Encrypt Database.

• The selected database file extension will be changed to .xdb.

• When you open a .xdb file, you will be asked to enter a password.

• To decrypt a encrypted database (.xdb), tap Tools > Decrypt Database.

• Note: Don't forget to decrypt the .xdb files before you synchronize them with the Desktop databases.

Copying table

Now you can copy the currently selected Table to a new Table.

On the Table tab, select a table you want to copy, then tap Tools > Copy Table.

List Control Changes

In-Cell Editing

Now supports in-cell editing in the List control. This feature allows you to alter data directly in a List control. To enable this feature, use the following property settings.

1. Tap the List control to select it.

2. Tap the Properties button or select Tools > Control(s) Properties.

3. On the Basic tab, set the FullRowSelect property to "No".

List Control Formatting

Supports field formatting in the List control. Tap the Data tab > ControlSource, select an expression and then tap the Format button.

Enhancements to the Form Editor

Undo Feature

Supports "Undo" (last action) in the Form Editor only. For example, you can select one or more controls on a form, move them and then select Tools > Undo to reverse the action. It will only undo changes to the size and position of a control.

 

Selecting Multiple Controls

You can now select multiple controls by using the Ctrl key. Tap the InputPanel Ctrl key first, and then tap the required controls. You can then move or set the properties of the selected controls.

 

Micro-adjustment

 

You can resize a control one pixel at a time by holding down the SHIFT key and using the ARROW keys.

 

Setting the tab order

New menu option Tools > Tab Order in the Form Editor. This is enables you to change the tab order.

To change the Tab Order:
1. Tap Tools > Tab Order.
2. Tap the controls in the order required.

To change Tab Order in a tab-control
1. Select a tab-control first.
2. Tap Tools > Tab Order.
3. Tap the controls in the order required.

 

Copy/Paste controls

 

 Now you can copy and paste controls to or from any form in a database.

Changes to the Macro Builder

The Add(+) and Update(*) buttons are no longer needed, as code lines are automatically updated in the Code List as they are entered. However, you can use the Add(+) button to duplicate a line of code.

New Tree Control

Supports the Tree Control.

See also:

TreeInsertItem() Insert an item into a tree control.
TreeSetItem() Set the text of the specified tree item.
TreeDeleteItem() Delete an item(s) from a tree control.
TreeSortItem() Sort the child items of the given parent in a tree control.

 

TreeControl.RootItemID() Returns the root item id in a Tree control.
TreeControl.ItemID() Returns the specified Tree control item's ID.
TreeControl.ItemText() Returns a specified Tree control item's text.

TabStop property for controls

Supports TabStop property for controls.
In the Form Editor, double-click a control to set its properties.

Passwords property for edit controls.

Supports the Password property for edit controls.

When the Password property of an EditBox is set to "Yes", any character typed in the control is stored as the character but is displayed as an asterisk (*).

Duplicating a record in table view and form view

Now you can easily duplicate the current record.

Tap Tools > Duplicate Record in table view, and File > Duplicate Record in form view.

New Events for Forms and Controls

OnPaint event for forms: The OnPaint event occurs when SprintDB repaint the form. This would be the best place for to use drawing commands like DrawLine(), DrawRectangle(), etc.

 

OnClick event for Label control: The OnClick event occurs when you click a control.  

Displaying more than 1 column in Dropdown control

Version 2.0 supports OutputExpr property for Dropdown control.

It allows you to display more than 1 column in a Dropdown control.

 

Example 

RowSourceType: Table/Query

RowSource: SELECT Customers.ID, Customers.CompanyName, Customers.PhoneNumber FROM Customers

ColumnCount: 3

BoundColumn: 1

VisibleColumn: not used in this case

OutputExpr: Customers.CompanyName+"-"+Customers.PhoneNumber

ClearType font

Supports ClearType font.

To use ClearType font:

• Tools > Layout > Use ClearType Font in main screen or table view.

• Set ClearTypeFont property to Yes in form's properties window.

New Macro/Script Actions

Importing/Exporting CSV

 

ExportToCSV()
Export specified record set to a .csv file.
ImportFromCSV()
Import records from specified .csv file into an existing table.

Working with the Pocket Outlook Contact Database

PolContactAdd()
Add a new contact.
PolContactDelete()
Delete a contact.
PolContactFind()
Find data in contact database.
PolContactFindNext()
Find next.
PolContactSort()
Sort on a column in contact database.

 

Working with Tree Control

TreeInsertItem()
Insert an item into a tree control.
TreeSetItem()
Set the text of the specified tree item.
TreeDeleteItem()
Delete an item(s) from a tree control.
TreeSortItem()
Sort the child items of the given parent item in a tree control.

 

Drawing commands

DrawLine()
Draw a line on the form screen.
DrawRectangle()
Draw a rectangle on a Form screen using the specified colors.
DrawEllipse()
Draw an ellipse in the specified bounding rectangle.
DrawText()
Draw text on form screen using the specified font.

New Macro/Script Functions

CreateFont()
Creates a font and returns the font handler.
GetDataType(tablefield)
Returns a table's field type as a string.
InputPwdBox()
Identical to InputBox(), but displays each character as an asterisk (*) as it is typed.

InputNumber()

Returns a number typed by the user, using the built-in numeric key pad.

GetPlatform()

Returns whether SprintDB Pro is running on a Pocket PC or Desktop PC.

 

Pocket Outlook Specific

 

PolContactCount() 
Returns the number of contacts in the database.
PolContactOID()
Returns the Object ID of an item in contact database.
PolContactRead()
Returns a column in a item.