#

# LogiView

## Combined Instructions: (Direct) Selection

| In addition to the functions and commands for selecting records using virtual widgets, LogiView also offers functions and commands for selections on the database level. The following commands and functions are available: command 'select' command 'where' command 'order_by' integer function 'exec_select
| This selection method ensures better response times than selection via virtual widgets. However, you need to know the exact layout of the accessed database tables and their links.
| ### Examples:
T | Ln | Cond/Act | R 01
A | 10 | select(NORM,STD) | yes
A | 20 | where("MAT.NAME"="maho-%") | yes
A | 30 | order_by("MAT.ISO"+) | yes
A | 40 | RC = exec_select(1) | yes