A double mouse click, or clicking a look up button, or
pressing the AltDown key pops up a selection browse. While the field is
selected, the up and down arrows enter the next or previous record. The
button is skipped when moving to the next field, avoiding an unnecessary
stop in data entry. You may optionally pop up the browse as soon as the
user presses a key without a matching record. The lookups utilize views
which may use ranges and filters. Related fields may be populated from
lookups; assignments can be disabled when a record is being edited.
Multiple lookups may be done using the same lookup file without aliasing.
Lookups without requiring a matching record in the lookup file. Some
additional features of this library are:
- All source code class library
- Works with ABC and Clarion (Legacy) applications.
- Generates very few lines of code.
- A Translation File (.trn) allows you to control the size, text, and
icon of the lookup button at run time.
- Record filtering and record validation.
- Resetting of the window for refreshing browses or other related
filtered lookups.
- Optional Disabling of related field assignments when records are
being changed.
- A large number of virtual methods.
- SQL Support
- Clarionet Support
Using local data allows multiple lookups into the same
file. The lookup browse does not have to be in the procedure tree and can
take parameters. The view can be hand coded if desired. The window can be
reset upon acceptance or new selection to handle filters on other lookups
and browses. Lookups can also be disabled when editing a record.
- Update of individual related fields can also be disabled when
updating a record.
- The disabled-on-edit property may be overridden if the field to
assign is blank when the window opens.
- The disable-on-edit property may also be overridden if the entry
field is blank.
- From normalized databases, the button handles all the code for
getting and displaying the lookup record and saving ID values.
A free update to version 10.01 is available to all
existing owners of PD Lookups.
You will need to order this on
ClarionShop.
You can download the most recent SAF file
here.
