FILLBOX |
Fillbox is used to fill a left list or a picking box.
Fillbox abrev [hint-cl]
|
Element |
Description |
Restrictions |
|
abrev |
Abbreviation that designates the picking box |
The box must be opened. |
|
hint_cl |
See Hint instruction |
None. |
# opening of the table (with the key : yitmref,yuom,yvatrat )
If !clalev([F:ZMT]) : Local File ZMOTTBX [ZMT] : Endif# display of the hierarchy elements
Treebox [ZMT] SEL
& [F:ZMT]YITMREF Titled "",
& [F:ZMT]YUOM Titled "",
& [F:ZMT]YVATRAT Titled ""
& Sized(160,240)
& Titled "Selection window"
& At(40,40)
& As [PIC]
Boxact [PIC] Fillbox [PIC]# entry in the hieracrhy picking box
$SAIPIC
Boxinp [PIC] Using RESU
Case RESU
When GSTAPIC
Repeat
Pick [PIC]
Case status
When 7: Break
When 37: Gosub SELECTION
When 41: Gosub DESELECTION
Endcase
Until 1=0
When GSTAPKF: Goto END
When GSTAESC, GSTAFIN: Goto END
Endcase
Goto SAIPIC
Fillbox is used to fill a left list or a picking box with the rrecordings of the associated table. This table can be derived from a link between several tables (Link instruction): It is possible to filter the recordings to be displayed and to sort them out via the Filter instruction.
It is now possible to optimize the read of recordings by defining, in addition to the sorting key defined by the filter, a key for the SQL query with the keyword Hint Key. In effect, in some cases, the sorting key is not optimum to execute a query. For instance, if the commands of a client need to be scanned in the number order, the key on the numbers is not adapted whereas the key on the client is more discriminant. To remedy this problem, a new syntax is active:
Filter [XXX]... order by key CLE1
Fillbox [XXX] Hint Key CLE2
If no key is discriminant for the scanning key, it is important not to force it, and thus to let the database run its normal course. In effect, if a client creates a key corresponding to the scanning criterion, said key will be automatically used by the database.
On the other hand, if this key is not created, the search concerns the file as a whole.
Fillbox [BPC] GAU_CHE Hint Key =""
For the scanning key
By default, the Adonix engine lets the database decide on the most appropriate scanning key for the read. The Hint Key ="" clause becomes the default option.
|
Error |
Description |
|
|
|
Boxact - Pick - Currbox - Setlbox - Dislbox - Hint
|
Copyright © Sage 1999 - 2007 |