The following conventions are used in both the Main Help system and the Tutorial

Naming Conventions Used in This User Guide

• Control Names, e.g. Buttons, Text Boxes, Labels, etc. are in Bold.
• Literals, i.e. Database names, Control names, etc. are in inverted commas, e.g. "My Tasks".

Actions

When selecting a Menu item, the > symbol indicates that you choose the first item followed by the second. For example: "Tap File > (then) New Database".

• 'Tap' means use the stylus to "Tap" the control (the same as a mouse click on your PC).
• 'Double-tap' means tap the control twice, rapidly (the same as mouse double-click).
• 'Tap & Hold' means tap the control and hold the stylus until the action occurs - usually a menu appearing.
• 'Tab' referes to the Tab control, except when referring to 'Tab Order' (version 2.0+).

Naming Conventions in SprintDB Pro

SprintDB Pro is not case-sensitive.

Form and Query Names -

• May include any character.
• May contain from 1 to 40 characters.

Form Control Names

• Names may be up to 40 characters in length.
• Any character can be used for Label, Button and List Control names.
• Use letters (a-z, A-Z), underscores, and numbers (0-9) for EditBox, CheckBox, DropDown Box control names and avoid words reserved by SQL. Square brackets([]) must be used to enclose control names that contain characters other than letters (a-z, A-Z), underscores, and numbers (0-9).

Table and Field Names

Square brackets ([]) must be used to enclose table or field names that are contain characters other than alphanumeric characters or the underscore character.

Expression Syntax

String Use

• Double or single quotation marks must be used to enclose strings. For example: "ab c", 'ab c', "a'b' c", 'a"b" c' are valid.
• You are not allowed to use '"',''','#' to enclose table or field names in SprintDB forms. For example: "table1"."field1", 'table1'.'field1', #table1#.#field1# are invalid in a SprintDB form.

Form Field Use

Tne control Name must be preceded by '&'. For example, "&age","&[age]" means the form field that has the name "age".

Data Types

• Text: Unicode character string, with a maximum of 255 characters.
• Memo: Variable length string that can hold up to 32,000 characters. It is typically used for more than 255 characters.
• Integer: 4-byte signed integer from -2,147,483,648 to 2,147,483,647.
• SmallInt: 2-byte signed integer from -32,768 to 32,767.
• Double: Double-precision floating point value.
• DateTime: Date object value.
• Yes/No: Logical or Boolean value. 0 is FALSE and 1 is TRUE.

<Top >