It is data object to view database data as Reporter.
If you select the 'Database' at 'Insert Basic Data', Setting (Database) dialogue box comes up such as <Figure 1>.
<Figure 1> Setting (Database) dialogue box
Database object is inserted such as <Figure 2>, by inputting the Filename or Connection string, Table name or Query string, Column name, Where string, Order by string.
Filename or Connection string can
input the string var by entering the MDB file(or selecting the
button) or Connection string, or
adding a '$' character in front of string var name. ($REPORT_WHERE_START etc)
Also, Table name or Query string, Column name, Where string, Order by string can input the string var, by depending on database format.
If you press the
button, Select Var dialogue box comes up. You can
set the parameter of database data object by selecting the string var, in this
dialogue box.
<Figure 2> Example of inserting database object
<Figure 3> is example of 'View as run mode' for <Figure 2> at LocalMain or Reporter Editor.
<Figure 3> Example of 'View as run mode' for <Figure 2>
You can edit Database object in cell text edit box, as following the order.
1) Letter for data start(=),
2) Data command(EtcDataBase),
3) Filename(MDB data) or Query string,
4) Table name,
5) Column name,
6) Where string,
7) Order by string
Example of editing a cell text) =EtcDataBase,C:\TestWork\REPORT_DATABASE\Database\test.mdb,OnOffList,EndTime,$REPORT_WHERE_START,[Date] ASC,
Relate items)
Insert menu in Reporter Editor
This examples can be referred at Project Manager Program by selecting the 'File | Restore'.