FILLBOX

Contents


Fillbox is used to fill a left list or a picking box.

Syntax

Fillbox abrev [hint-cl] 

Parameters

Element

Description

Restrictions

abrev

Abbreviation that designates the picking box

The box must be opened.

hint_cl

See Hint instruction

None.

Examples

# 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

Description and comments

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.

New to the versions 130 and 135

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 =""

New to version 140

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.

 

Associated errors

Error

Description

 

 

Associated keywords

Boxact  -   Pick  -  Currbox  -  Setlbox  -   Dislbox - Hint


CONTENTS

Copyright © Sage 1999 - 2007