| columns_searchtable |
|
SELECT |
Details |
SELECT
"COLUMN_NAME",
"TYPE_NAME",
"COLUMN_SIZE",
"COLUMN_DEF" "Default Value"
FROM
"INFORMATION_SCHEMA"."SYSTEM_COLUMNS"
WHERE
"TABLE_NAME" = 'searchtable' |
| filterquery |
listbox_1_filterquery (Query)
listbox_2_filterquery (Query)
filter_with_macros_1 (Form)
filter_with_macros_2 (Form)
filter_without_macros (Form) |
SELECT |
Details |
SELECT
"Nr.",
IFNULL("Sys.", 0) "Sys.",
"Verw.",
"Kuerz.",
IFNULL("Art", 0) "Art",
"Autor",
"Titel",
"Jahr",
"Schlagworte",
"Zunummer",
"ISBN"
FROM
"searchtable" AS "searchtable"
WHERE
"Sys." = IFNULL(
(
SELECT
"filter_1"
FROM
"filter"),
"Sys.")
AND "Art" = IFNULL(
(
SELECT
"filter_2"
FROM
"filter"),
"Art") |
| listbox_1 |
filter_with_macros_1|listbox1 (Control)
filter_with_macros_2|listbox1 (Control) |
SELECT |
Details |
SELECT
IFNULL(
"Sys." || ' - ' || "quantity", 'empty - ' || "quantity"
),
"Sys."
FROM
"listbox_1_view" |
| listbox_1_filterquery |
|
SELECT |
Details |
SELECT
"Sys." || ' - ' || "quantity" "display",
"Sys."
FROM
(
SELECT
COUNT("Nr.") "quantity",
"Sys."
FROM
"filterquery"
GROUP BY
"Sys.")
ORDER BY
"Sys." |
| listbox_1_simple |
filter_without_macros|listbox1 (Control) |
SELECT |
Details |
SELECT
"Sys.",
"Sys."
FROM
"searchtable"
GROUP BY
"Sys."
ORDER BY
"Sys." ASC |
| listbox_2 |
filter_with_macros_1|listbox2 (Control)
filter_with_macros_2|listbox2 (Control) |
SELECT |
Details |
SELECT
IFNULL(
"Art" || ' - ' || "quantity", 'empty - ' || "quantity"
),
"Art"
FROM
"listbox_2_view" |
| listbox_2_filterquery |
|
SELECT |
Details |
SELECT
"Art" || ' - ' || "quantity" "display",
"Art"
FROM
(
SELECT
COUNT("Nr.") "quantity",
"Art"
FROM
"filterquery"
GROUP BY
"Art")
ORDER BY
"Art" |
| listbox_2_simple |
filter_without_macros|listbox2 (Control) |
SELECT |
Details |
SELECT
"Art",
"Art"
FROM
"searchtable"
GROUP BY
"Art"
ORDER BY
"Art" ASC |
| searchquery |
searchquery (Form) |
SELECT |
Details |
SELECT
*
FROM
"searchtable"
WHERE
"Nr." IN (
SELECT
"Nr."
FROM
"searchtmp")
OR "Nr." = CASE WHEN (
SELECT
COUNT("Nr.")
FROM
"searchtmp") > 0 THEN '-1' ELSE "Nr." END |
