A sub box
Use it to have a table of 2 rows.
<box rows="6" columns="4"> <cell expand="false" xpos="1"> </cell> <cell expand="false" xpos="2"> </cell> <cell expand="true" xpos="1" ypos="6" xspan="2"> </cell> </box>
A label
The easy one.
<label>id</label>
A display box
To display information from the database.
the fild make the link to the curent dbobject, in this case the payment-win
<entry readonly="true" alignment="right" minwidth="20"> <field>id</field> </entry>
An entry box
Same think that display box but editable.
The inputrestrict restric the type of data witch the user enter.
<entry minwidth="130" readonly="false"> <field>paymentdate</field> <inputrestrict>date</inputrestrict> </entry>
A combo box
For this one whe are to display the payment type.
There is a relation as forein key in the datbase between payment.paymenttypeid and paymentype.id.
To display the descriptions of the paymenttype we need another dbobject.
<dbobject>
<sql>
SELECT * FROM paymenttype
</sql>
</dbobject>
We need also the field to display, and the reference field.
In this case the reference is the id and the dispaly is the description.
<primaryfield>id</primaryfield> <showfield>description</showfield>
We also need to specify the link to the payment table.
<field>paymenttypeid</field>
All together now.
<dropdown>
<lookup>
<dbobject>
<sql>
SELECT * FROM paymenttype
</sql>
</dbobject>
<primaryfield>id</primaryfield>
<showfield>description</showfield>
</lookup>
<field>paymenttypeid</field>
</dropdown>
Text view
Just bigger than an entry box.
<textview> <field>note</field> </textview>
A list
A list to chose throw the existant records.
This one display the field date and the field amount for eatch record in the database.
<list name="paymentlist" sortable="true" minheight="130">
<column title="Date">
<field>paymentdate</field>
</column>
<column title="Amount">
<field>amount</field>
</column>
</list>
Previous page Next page
