<< Click to Display Table of Contents >> Database table |
|
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 |
|
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.