Fieldpine Logo Documentation Home  
User Interface Home

The combo directive allows you to place a drop down select control onto an XML screen. It is only available for XML screens and does not work on UI screens.

psql(String)

Supplies a PSQL statement to select values from the database. The string is used literally and not translated

psqlsymbols(String)

3 Jul 2015, P1868 Supplies a PSQL statement to select values from the database, but the "String" is processed using symbol translation before use. Symbol translation only occurs when the combo is loaded.

font(string)

Sets the font characteristics to use in the combo control

display(field)

Sets the name of the field from the database to display to the user. Typically this is a field like "description" for products.

displaymessage()

Not documented for use

values(list)

initialvalue(value)

unique(field)

Sets the name of the field from the database that is used as the "value" of this combo. Typically this is a field like "pid" for products.

create()

Not documented for use

ifilter()

Deprecated. Do not use for new installations.

onewritelock

Locks the combo from change if a value has already been set. This is used where an option can only be selected once and is then permanently locked to that value.


Examples of Use

Draw a simple screen with two combo selectors. Both use psql to load values, one is using symbol translation
<screen name="ComboTest" size="208,73" style="center,sysmenu" title="ComboTest" font="Arial,12" default="run" cancel="Cancel">

<text at="5,5" size="40,100">
    <label>Combo Test2</label>
    <font>Arial,16</font>
</text>

<combo at="40,30" name="crc" size="80,112">
    <psql>?products,pid,lt,1124</psql>
    <display>description</display>
    <unique>pid</unique>
</combo>

<fpscript>
     set xyz = string(?products,pid,lt,1124)
</fpscript>

<combo at="40,50" name="crc2" size="80,112">
    <psqlsymbols>%xyz%</psqlsymbols>
    <display>description</display>
    <unique>pid</unique>
</combo>

</screen>