|
<< Click to Display Table of Contents >> Database table |
  
|
|
<< Click to Display Table of Contents >> Database table |
|
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. |
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:
1. disablesavereport - disable "Save report" menu item in the context menu.
2. disableprint - disable "Print" menu item in the context menu.
3. columnwidtharray - use this value to setup different column widths. Example:
Objects.Databasetable.columnwidtharray = "[10, 150, 150, 200]";
4. rownumber - number of the row is choosen (clicked) by user.
5. resultset - if you want to fill data from Result set, set name of the result set here.
6. 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.