Database table

<< Click to Display Table of Contents >>

Navigation:  Project > Screens > Graphical objects > Databases library >

Database table

Previous pageReturn to chapter overviewNext page

databasetable

 

Let's look at the "General" properties of this object  (properties not listed in the table are common to all objects, you can read about them here).

 

Property

ST script field

Description

Database

databasename

Database name. If database name contains “jdbc:mysql” it means address of MySQL database. If database name contains "jdbc:mssql" it means address of MSSQL database. If database name contains "jdbc:postgresql" it means address of PostgreSQL database.  If database name doesn't contain "jdbc" it means address of SQLLite database.

Username

username

Username for MySQL database.

Password

password

Password for MySQL database.

Table name

tablename

Name of the table.

Use title

usetitle

Use title for the table or not.

Title

title

Title of the table.

Font size

fontsize

Size of the text's font.

Column width

columnwidth

Set width of the columns.

Use custom columns

 

Check if you want to use custom columns.

Columns

 

clip0017

where:

1. DB column name - database column name of the DB you use for table.

2. Title - title you want to use for column.

3. Width - width of the column.

4. Background color - background color of the cell depending on value range.

5. Text color - text color of the cell depending on value range.

 

Also Database Table object has several properties that you can’t setup by using settings dialog window, but you can setup by using ST script:  

disablesavereport - disable "Save report" menu item in the context menu.

disableprint -  disable "Print" menu item in the context menu.

columnwidtharray - use this value to setup different column widths. Example: Objects.Databasetable.columnwidtharray = "[10, 150, 150, 200]";

rownumber - number of the row is choosen (clicked) by user.

resultset* - if you want to fill data from Result set, set name of the result set here.

csv* - if you want to fill data from .csv file set name of the file here (if you use just name the file will be gotten from the DB folder. You can use the full path also).

*resultset and csv don't works on iOS version.

 

Properties from the "Flash" tab are described here.

Properties from the "Rotation" tab are described here.

Properties from the "Motion" tab are described here.

Properties from the "Visibility" tab are described here.