|
columns_searchtable | COLUMN_NAME | VARCHAR | SYSTEM_COLUMNS | COLUMN_NAME |
COLUMN_SIZE | INTEGER | SYSTEM_COLUMNS | COLUMN_SIZE | |
Default Value | VARCHAR | SYSTEM_COLUMNS | Default Value | |
TYPE_NAME | VARCHAR | SYSTEM_COLUMNS | TYPE_NAME | |
filterquery | Art | IFNULL( "Art", 0 ) | ||
Autor | VARCHAR | searchtable (Table) | Autor | |
ISBN | VARCHAR | searchtable (Table) | ISBN | |
Jahr | NUMERIC | searchtable (Table) | Jahr | |
Kuerz. | VARCHAR | searchtable (Table) | Kuerz. | |
Nr. | INTEGER | searchtable (Table) | Nr. | |
Schlagworte | VARCHAR | searchtable (Table) | Schlagworte | |
Sys. | IFNULL( "Sys.", 0 ) | |||
Titel | VARCHAR | searchtable (Table) | Titel | |
Verw. | VARCHAR | searchtable (Table) | Verw. | |
Zunummer | VARCHAR | searchtable (Table) | Zunummer | |
listbox_1 | IFNULL( "Sys." || ' - ' || "quantity", 'empty - ' || "quantity" ) | IFNULL( "Sys." || ' - ' || "quantity", 'empty - ' || "quantity" ) | ||
Sys. | VARCHAR | listbox_1_view (Table) | Sys. | |
listbox_1_filterquery | display | VARCHAR | display | |
Sys. | LONGVARCHAR | SYSTEM_SUBQUERY | Sys. | |
listbox_1_simple | Sys. | VARCHAR | searchtable (Table) | Sys. |
Sys.1 | VARCHAR | searchtable (Table) | Sys. | |
listbox_2 | Art | VARCHAR | listbox_2_view (Table) | Art |
IFNULL( "Art" || ' - ' || "quantity", 'empty - ' || "quantity" ) | IFNULL( "Art" || ' - ' || "quantity", 'empty - ' || "quantity" ) | |||
listbox_2_filterquery | Art | LONGVARCHAR | SYSTEM_SUBQUERY | Art |
display | VARCHAR | display | ||
listbox_2_simple | Art | VARCHAR | searchtable (Table) | Art |
Art1 | VARCHAR | searchtable (Table) | Art | |
searchquery | Art | VARCHAR | searchtable (Table) | Art |
Autor | VARCHAR | searchtable (Table) | Autor | |
Datum | DATE | searchtable (Table) | Datum | |
ISBN | VARCHAR | searchtable (Table) | ISBN | |
Jahr | NUMERIC | searchtable (Table) | Jahr | |
Kuerz. | VARCHAR | searchtable (Table) | Kuerz. | |
Nr. | INTEGER | searchtable (Table) | Nr. | |
Schlagworte | VARCHAR | searchtable (Table) | Schlagworte | |
Sys. | VARCHAR | searchtable (Table) | Sys. | |
Titel | VARCHAR | searchtable (Table) | Titel | |
Verw. | VARCHAR | searchtable (Table) | Verw. | |
Zunummer | VARCHAR | searchtable (Table) | Zunummer |