Table of contents
Media_with_Macros

• Tables
  • Adress
  • Author
  • Author_Add
  • Category
  • Class
  • Filter
  • Gender
  • Grade
  • Loan
  • Media
  • Mediastyle
  • Postcode
  • Preferences
  • Publisher
  • Reader
  • Recall
  • rel_Media_Author
  • rel_Reader_Schoolclass
  • Schoolclass
  • Search
  • Street
  • Subtitle
  • Town
  • View_EAN13_Labels
  • View_EAN13_Substring
  • View_Label_Media
  • View_Media_Charts
  • View_Media_complete
  • View_Media_Search_Result
  • View_MediaID_Title_Author
  • View_Recall_current
  • View_Reminder
  • View_Report_Recall
• Queries
  • Barcode_EAN13_ttf_Report
  • Current_Date
  • ISBN_Test
  • Listbox_Title_MediaID_not_loan
  • Loan_not_locked
  • Media_Chart
  • Media_Input_Search_Result
  • Media_Loan_Balance_Time
  • Media_Loan_Balance_Time_Recall
  • Media_Recall_Reader
  • Reader_Input_Filter
  • Recall_Recallnumber
• Forms
  • Loan
  • Loan_Barcode
  • Maintenance
  • Media
  • Reader_Admission
  • Recall
• Dialogs
  • Dialog_TableAdjustment
• Modules
  • AA_Variables
  • Backup
  • Comboboxes
  • Maintenance
  • Navigation
  • Print
  • Refreshing
• Missing items
• Index

List of fields by query

Query name	Field name	Field type	Source table	Source field
Barcode_EAN13_ttf_Report	S_1			"1_1" || CASE WHEN ( "1_2" = 1 ) THEN 'B' WHEN ( "1_2" = 2 ) THEN 'C' WHEN ( "1_2" = 3 ) THEN 'D' WHEN ( "1_2" = 4 ) THEN 'E' WHEN ( "1_2" = 5 ) THEN 'F' WHEN ( "1_2" = 6 ) THEN 'G' WHEN ( "1_2" = 7 ) THEN 'H' WHEN ( "1_2" = 8 ) THEN 'I' WHEN ( "1_2" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "1_3" = 1 ) THEN 'B' WHEN ( "1_3" = 2 ) THEN 'C' WHEN ( "1_3" = 3 ) THEN 'D' WHEN ( "1_3" = 4 ) THEN 'E' WHEN ( "1_3" = 5 ) THEN 'F' WHEN ( "1_3" = 6 ) THEN 'G' WHEN ( "1_3" = 7 ) THEN 'H' WHEN ( "1_3" = 8 ) THEN 'I' WHEN ( "1_3" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "1_4" = 1 ) THEN 'B' WHEN ( "1_4" = 2 ) THEN 'C' WHEN ( "1_4" = 3 ) THEN 'D' WHEN ( "1_4" = 4 ) THEN 'E' WHEN ( "1_4" = 5 ) THEN 'F' WHEN ( "1_4" = 6 ) THEN 'G' WHEN ( "1_4" = 7 ) THEN 'H' WHEN ( "1_4" = 8 ) THEN 'I' WHEN ( "1_4" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "1_5" = 1 ) THEN 'B' WHEN ( "1_5" = 2 ) THEN 'C' WHEN ( "1_5" = 3 ) THEN 'D' WHEN ( "1_5" = 4 ) THEN 'E' WHEN ( "1_5" = 5 ) THEN 'F' WHEN ( "1_5" = 6 ) THEN 'G' WHEN ( "1_5" = 7 ) THEN 'H' WHEN ( "1_5" = 8 ) THEN 'I' WHEN ( "1_5" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "1_6" = 1 ) THEN 'B' WHEN ( "1_6" = 2 ) THEN 'C' WHEN ( "1_6" = 3 ) THEN 'D' WHEN ( "1_6" = 4 ) THEN 'E' WHEN ( "1_6" = 5 ) THEN 'F' WHEN ( "1_6" = 6 ) THEN 'G' WHEN ( "1_6" = 7 ) THEN 'H' WHEN ( "1_6" = 8 ) THEN 'I' WHEN ( "1_6" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "1_7" = 1 ) THEN 'B' WHEN ( "1_7" = 2 ) THEN 'C' WHEN ( "1_7" = 3 ) THEN 'D' WHEN ( "1_7" = 4 ) THEN 'E' WHEN ( "1_7" = 5 ) THEN 'F' WHEN ( "1_7" = 6 ) THEN 'G' WHEN ( "1_7" = 7 ) THEN 'H' WHEN ( "1_7" = 8 ) THEN 'I' WHEN ( "1_7" = 9 ) THEN 'J' ELSE 'A' END || '*' || CASE WHEN ( "1_8" = 1 ) THEN 'b' WHEN ( "1_8" = 2 ) THEN 'c' WHEN ( "1_8" = 3 ) THEN 'd' WHEN ( "1_8" = 4 ) THEN 'e' WHEN ( "1_8" = 5 ) THEN 'f' WHEN ( "1_8" = 6 ) THEN 'g' WHEN ( "1_8" = 7 ) THEN 'h' WHEN ( "1_8" = 8 ) THEN 'i' WHEN ( "1_8" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "1_9" = 1 ) THEN 'b' WHEN ( "1_8" = 2 ) THEN 'c' WHEN ( "1_9" = 3 ) THEN 'd' WHEN ( "1_9" = 4 ) THEN 'e' WHEN ( "1_9" = 5 ) THEN 'f' WHEN ( "1_9" = 6 ) THEN 'g' WHEN ( "1_9" = 7 ) THEN 'h' WHEN ( "1_9" = 8 ) THEN 'i' WHEN ( "1_9" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "1_10" = 1 ) THEN 'b' WHEN ( "1_10" = 2 ) THEN 'c' WHEN ( "1_10" = 3 ) THEN 'd' WHEN ( "1_10" = 4 ) THEN 'e' WHEN ( "1_10" = 5 ) THEN 'f' WHEN ( "1_10" = 6 ) THEN 'g' WHEN ( "1_10" = 7 ) THEN 'h' WHEN ( "1_10" = 8 ) THEN 'i' WHEN ( "1_10" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "1_11" = 1 ) THEN 'b' WHEN ( "1_11" = 2 ) THEN 'c' WHEN ( "1_11" = 3 ) THEN 'd' WHEN ( "1_11" = 4 ) THEN 'e' WHEN ( "1_11" = 5 ) THEN 'f' WHEN ( "1_11" = 6 ) THEN 'g' WHEN ( "1_11" = 7 ) THEN 'h' WHEN ( "1_11" = 8 ) THEN 'i' WHEN ( "1_11" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "1_12" = 1 ) THEN 'b' WHEN ( "1_12" = 2 ) THEN 'c' WHEN ( "1_12" = 3 ) THEN 'd' WHEN ( "1_12" = 4 ) THEN 'e' WHEN ( "1_12" = 5 ) THEN 'f' WHEN ( "1_12" = 6 ) THEN 'g' WHEN ( "1_12" = 7 ) THEN 'h' WHEN ( "1_12" = 8 ) THEN 'i' WHEN ( "1_12" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "1_13" = 1 ) THEN 'b' WHEN ( "1_13" = 2 ) THEN 'c' WHEN ( "1_13" = 3 ) THEN 'd' WHEN ( "1_13" = 4 ) THEN 'e' WHEN ( "1_13" = 5 ) THEN 'f' WHEN ( "1_13" = 6 ) THEN 'g' WHEN ( "1_13" = 7 ) THEN 'h' WHEN ( "1_13" = 8 ) THEN 'i' WHEN ( "1_13" = 9 ) THEN 'j' ELSE 'a' END || '+'
	S_2			"2_1" || CASE WHEN ( "2_2" = 1 ) THEN 'B' WHEN ( "2_2" = 2 ) THEN 'C' WHEN ( "2_2" = 3 ) THEN 'D' WHEN ( "2_2" = 4 ) THEN 'E' WHEN ( "2_2" = 5 ) THEN 'F' WHEN ( "2_2" = 6 ) THEN 'G' WHEN ( "2_2" = 7 ) THEN 'H' WHEN ( "2_2" = 8 ) THEN 'I' WHEN ( "2_2" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "2_3" = 1 ) THEN 'B' WHEN ( "2_3" = 2 ) THEN 'C' WHEN ( "2_3" = 3 ) THEN 'D' WHEN ( "2_3" = 4 ) THEN 'E' WHEN ( "2_3" = 5 ) THEN 'F' WHEN ( "2_3" = 6 ) THEN 'G' WHEN ( "2_3" = 7 ) THEN 'H' WHEN ( "2_3" = 8 ) THEN 'I' WHEN ( "2_3" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "2_4" = 1 ) THEN 'B' WHEN ( "2_4" = 2 ) THEN 'C' WHEN ( "2_4" = 3 ) THEN 'D' WHEN ( "2_4" = 4 ) THEN 'E' WHEN ( "2_4" = 5 ) THEN 'F' WHEN ( "2_4" = 6 ) THEN 'G' WHEN ( "2_4" = 7 ) THEN 'H' WHEN ( "2_4" = 8 ) THEN 'I' WHEN ( "2_4" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "2_5" = 1 ) THEN 'B' WHEN ( "2_5" = 2 ) THEN 'C' WHEN ( "2_5" = 3 ) THEN 'D' WHEN ( "2_5" = 4 ) THEN 'E' WHEN ( "2_5" = 5 ) THEN 'F' WHEN ( "2_5" = 6 ) THEN 'G' WHEN ( "2_5" = 7 ) THEN 'H' WHEN ( "2_5" = 8 ) THEN 'I' WHEN ( "2_5" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "2_6" = 1 ) THEN 'B' WHEN ( "2_6" = 2 ) THEN 'C' WHEN ( "2_6" = 3 ) THEN 'D' WHEN ( "2_6" = 4 ) THEN 'E' WHEN ( "2_6" = 5 ) THEN 'F' WHEN ( "2_6" = 6 ) THEN 'G' WHEN ( "2_6" = 7 ) THEN 'H' WHEN ( "2_6" = 8 ) THEN 'I' WHEN ( "2_6" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "2_7" = 1 ) THEN 'B' WHEN ( "2_7" = 2 ) THEN 'C' WHEN ( "2_7" = 3 ) THEN 'D' WHEN ( "2_7" = 4 ) THEN 'E' WHEN ( "2_7" = 5 ) THEN 'F' WHEN ( "2_7" = 6 ) THEN 'G' WHEN ( "2_7" = 7 ) THEN 'H' WHEN ( "2_7" = 8 ) THEN 'I' WHEN ( "2_7" = 9 ) THEN 'J' ELSE 'A' END || '*' || CASE WHEN ( "2_8" = 1 ) THEN 'b' WHEN ( "2_8" = 2 ) THEN 'c' WHEN ( "2_8" = 3 ) THEN 'd' WHEN ( "2_8" = 4 ) THEN 'e' WHEN ( "2_8" = 5 ) THEN 'f' WHEN ( "2_8" = 6 ) THEN 'g' WHEN ( "2_8" = 7 ) THEN 'h' WHEN ( "2_8" = 8 ) THEN 'i' WHEN ( "2_8" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "2_9" = 1 ) THEN 'b' WHEN ( "2_8" = 2 ) THEN 'c' WHEN ( "2_9" = 3 ) THEN 'd' WHEN ( "2_9" = 4 ) THEN 'e' WHEN ( "2_9" = 5 ) THEN 'f' WHEN ( "2_9" = 6 ) THEN 'g' WHEN ( "2_9" = 7 ) THEN 'h' WHEN ( "2_9" = 8 ) THEN 'i' WHEN ( "2_9" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "2_10" = 1 ) THEN 'b' WHEN ( "2_10" = 2 ) THEN 'c' WHEN ( "2_10" = 3 ) THEN 'd' WHEN ( "2_10" = 4 ) THEN 'e' WHEN ( "2_10" = 5 ) THEN 'f' WHEN ( "2_10" = 6 ) THEN 'g' WHEN ( "2_10" = 7 ) THEN 'h' WHEN ( "2_10" = 8 ) THEN 'i' WHEN ( "2_10" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "2_11" = 1 ) THEN 'b' WHEN ( "2_11" = 2 ) THEN 'c' WHEN ( "2_11" = 3 ) THEN 'd' WHEN ( "2_11" = 4 ) THEN 'e' WHEN ( "2_11" = 5 ) THEN 'f' WHEN ( "2_11" = 6 ) THEN 'g' WHEN ( "2_11" = 7 ) THEN 'h' WHEN ( "2_11" = 8 ) THEN 'i' WHEN ( "2_11" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "2_12" = 1 ) THEN 'b' WHEN ( "2_12" = 2 ) THEN 'c' WHEN ( "2_12" = 3 ) THEN 'd' WHEN ( "2_12" = 4 ) THEN 'e' WHEN ( "2_12" = 5 ) THEN 'f' WHEN ( "2_12" = 6 ) THEN 'g' WHEN ( "2_12" = 7 ) THEN 'h' WHEN ( "2_12" = 8 ) THEN 'i' WHEN ( "2_12" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "2_13" = 1 ) THEN 'b' WHEN ( "2_13" = 2 ) THEN 'c' WHEN ( "2_13" = 3 ) THEN 'd' WHEN ( "2_13" = 4 ) THEN 'e' WHEN ( "2_13" = 5 ) THEN 'f' WHEN ( "2_13" = 6 ) THEN 'g' WHEN ( "2_13" = 7 ) THEN 'h' WHEN ( "2_13" = 8 ) THEN 'i' WHEN ( "2_13" = 9 ) THEN 'j' ELSE 'a' END || '+'
	S_3			"3_1" || CASE WHEN ( "3_2" = 1 ) THEN 'B' WHEN ( "3_2" = 2 ) THEN 'C' WHEN ( "3_2" = 3 ) THEN 'D' WHEN ( "3_2" = 4 ) THEN 'E' WHEN ( "3_2" = 5 ) THEN 'F' WHEN ( "3_2" = 6 ) THEN 'G' WHEN ( "3_2" = 7 ) THEN 'H' WHEN ( "3_2" = 8 ) THEN 'I' WHEN ( "3_2" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "3_3" = 1 ) THEN 'B' WHEN ( "3_3" = 2 ) THEN 'C' WHEN ( "3_3" = 3 ) THEN 'D' WHEN ( "3_3" = 4 ) THEN 'E' WHEN ( "3_3" = 5 ) THEN 'F' WHEN ( "3_3" = 6 ) THEN 'G' WHEN ( "3_3" = 7 ) THEN 'H' WHEN ( "3_3" = 8 ) THEN 'I' WHEN ( "3_3" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "3_4" = 1 ) THEN 'B' WHEN ( "3_4" = 2 ) THEN 'C' WHEN ( "3_4" = 3 ) THEN 'D' WHEN ( "3_4" = 4 ) THEN 'E' WHEN ( "3_4" = 5 ) THEN 'F' WHEN ( "3_4" = 6 ) THEN 'G' WHEN ( "3_4" = 7 ) THEN 'H' WHEN ( "3_4" = 8 ) THEN 'I' WHEN ( "3_4" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "3_5" = 1 ) THEN 'B' WHEN ( "3_5" = 2 ) THEN 'C' WHEN ( "3_5" = 3 ) THEN 'D' WHEN ( "3_5" = 4 ) THEN 'E' WHEN ( "3_5" = 5 ) THEN 'F' WHEN ( "3_5" = 6 ) THEN 'G' WHEN ( "3_5" = 7 ) THEN 'H' WHEN ( "3_5" = 8 ) THEN 'I' WHEN ( "3_5" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "3_6" = 1 ) THEN 'B' WHEN ( "3_6" = 2 ) THEN 'C' WHEN ( "3_6" = 3 ) THEN 'D' WHEN ( "3_6" = 4 ) THEN 'E' WHEN ( "3_6" = 5 ) THEN 'F' WHEN ( "3_6" = 6 ) THEN 'G' WHEN ( "3_6" = 7 ) THEN 'H' WHEN ( "3_6" = 8 ) THEN 'I' WHEN ( "3_6" = 9 ) THEN 'J' ELSE 'A' END || CASE WHEN ( "3_7" = 1 ) THEN 'B' WHEN ( "3_7" = 2 ) THEN 'C' WHEN ( "3_7" = 3 ) THEN 'D' WHEN ( "3_7" = 4 ) THEN 'E' WHEN ( "3_7" = 5 ) THEN 'F' WHEN ( "3_7" = 6 ) THEN 'G' WHEN ( "3_7" = 7 ) THEN 'H' WHEN ( "3_7" = 8 ) THEN 'I' WHEN ( "3_7" = 9 ) THEN 'J' ELSE 'A' END || '*' || CASE WHEN ( "3_8" = 1 ) THEN 'b' WHEN ( "3_8" = 2 ) THEN 'c' WHEN ( "3_8" = 3 ) THEN 'd' WHEN ( "3_8" = 4 ) THEN 'e' WHEN ( "3_8" = 5 ) THEN 'f' WHEN ( "3_8" = 6 ) THEN 'g' WHEN ( "3_8" = 7 ) THEN 'h' WHEN ( "3_8" = 8 ) THEN 'i' WHEN ( "3_8" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "3_9" = 1 ) THEN 'b' WHEN ( "3_8" = 2 ) THEN 'c' WHEN ( "3_9" = 3 ) THEN 'd' WHEN ( "3_9" = 4 ) THEN 'e' WHEN ( "3_9" = 5 ) THEN 'f' WHEN ( "3_9" = 6 ) THEN 'g' WHEN ( "3_9" = 7 ) THEN 'h' WHEN ( "3_9" = 8 ) THEN 'i' WHEN ( "3_9" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "3_10" = 1 ) THEN 'b' WHEN ( "3_10" = 2 ) THEN 'c' WHEN ( "3_10" = 3 ) THEN 'd' WHEN ( "3_10" = 4 ) THEN 'e' WHEN ( "3_10" = 5 ) THEN 'f' WHEN ( "3_10" = 6 ) THEN 'g' WHEN ( "3_10" = 7 ) THEN 'h' WHEN ( "3_10" = 8 ) THEN 'i' WHEN ( "3_10" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "3_11" = 1 ) THEN 'b' WHEN ( "3_11" = 2 ) THEN 'c' WHEN ( "3_11" = 3 ) THEN 'd' WHEN ( "3_11" = 4 ) THEN 'e' WHEN ( "3_11" = 5 ) THEN 'f' WHEN ( "3_11" = 6 ) THEN 'g' WHEN ( "3_11" = 7 ) THEN 'h' WHEN ( "3_11" = 8 ) THEN 'i' WHEN ( "3_11" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "3_12" = 1 ) THEN 'b' WHEN ( "3_12" = 2 ) THEN 'c' WHEN ( "3_12" = 3 ) THEN 'd' WHEN ( "3_12" = 4 ) THEN 'e' WHEN ( "3_12" = 5 ) THEN 'f' WHEN ( "3_12" = 6 ) THEN 'g' WHEN ( "3_12" = 7 ) THEN 'h' WHEN ( "3_12" = 8 ) THEN 'i' WHEN ( "3_12" = 9 ) THEN 'j' ELSE 'a' END || CASE WHEN ( "3_13" = 1 ) THEN 'b' WHEN ( "3_13" = 2 ) THEN 'c' WHEN ( "3_13" = 3 ) THEN 'd' WHEN ( "3_13" = 4 ) THEN 'e' WHEN ( "3_13" = 5 ) THEN 'f' WHEN ( "3_13" = 6 ) THEN 'g' WHEN ( "3_13" = 7 ) THEN 'h' WHEN ( "3_13" = 8 ) THEN 'i' WHEN ( "3_13" = 9 ) THEN 'j' ELSE 'a' END || '+'
Current_Date	CURDATE( )			CURDATE( )
	Current_Date			CURDATE( )
ISBN_Test	ID	INTEGER	a	ID
	ISBN	NUMERIC	a	ISBN
	Test			CASE WHEN ( ( IFNULL( ( SELECT "ISBN13_Test" FROM ( SELECT "ID", MOD( ( ( TRUNCATE( "ISBN", - 12 ) / 1000000000000 - TRUNCATE( "ISBN", - 13 ) / 1000000000000 ) + 3 * ( TRUNCATE( "ISBN", - 11 ) / 100000000000 - TRUNCATE( "ISBN", - 12 ) / 100000000000 ) + ( TRUNCATE( "ISBN", - 10 ) / 10000000000 - TRUNCATE( "ISBN", - 11 ) / 10000000000 ) + 3 * ( TRUNCATE( "ISBN", - 9 ) / 1000000000 - TRUNCATE( "ISBN", - 10 ) / 1000000000 ) + ( TRUNCATE( "ISBN", - 8 ) / 100000000 - TRUNCATE( "ISBN", - 9 ) / 100000000 ) + 3 * ( TRUNCATE( "ISBN", - 7 ) / 10000000 - TRUNCATE( "ISBN", - 8 ) / 10000000 ) + ( TRUNCATE( "ISBN", - 6 ) / 1000000 - TRUNCATE( "ISBN", - 7 ) / 1000000 ) + 3 * ( TRUNCATE( "ISBN", - 5 ) / 100000 - TRUNCATE( "ISBN", - 6 ) / 100000 ) + ( TRUNCATE( "ISBN", - 4 ) / 10000 - TRUNCATE( "ISBN", - 5 ) / 10000 ) + 3 * ( TRUNCATE( "ISBN", - 3 ) / 1000 - TRUNCATE( "ISBN", - 4 ) / 1000 ) + ( TRUNCATE( "ISBN", - 2 ) / 100 - TRUNCATE( "ISBN", - 3 ) / 100 ) + 3 * ( TRUNCATE( "ISBN", - 1 ) / 10 - TRUNCATE( "ISBN", - 2 ) / 10 ) + ( "ISBN" - TRUNCATE( "ISBN", - 1 ) ) ), 10 ) "ISBN13_Test" FROM "Media" ) AS "I_Test" WHERE "ID" = "a"."ID" AND "a"."ISBN" > 9999999999 ), 0 ) + IFNULL( ( SELECT "ISBN10_Test" FROM ( SELECT "ID", MOD( CEILING( ( TRUNCATE( "ISBN", - 9 ) / 1000000000 - TRUNCATE( "ISBN", - 10 ) / 1000000000 ) + 2 * ( TRUNCATE( "ISBN", - 8 ) / 100000000 - TRUNCATE( "ISBN", - 9 ) / 100000000 ) + 3 * ( TRUNCATE( "ISBN", - 7 ) / 10000000 - TRUNCATE( "ISBN", - 8 ) / 10000000 ) + 4 * ( TRUNCATE( "ISBN", - 6 ) / 1000000 - TRUNCATE( "ISBN", - 7 ) / 1000000 ) + 5 * ( TRUNCATE( "ISBN", - 5 ) / 100000 - TRUNCATE( "ISBN", - 6 ) / 100000 ) + 6 * ( TRUNCATE( "ISBN", - 4 ) / 10000 - TRUNCATE( "ISBN", - 5 ) / 10000 ) + 7 * ( TRUNCATE( "ISBN", - 3 ) / 1000 - TRUNCATE( "ISBN", - 4 ) / 1000 ) + 8 * ( TRUNCATE( "ISBN", - 2 ) / 100 - TRUNCATE( "ISBN", - 3 ) / 100 ) + 9 * ( TRUNCATE( "ISBN", - 1 ) / 10 - TRUNCATE( "ISBN", - 2 ) / 10 ) + 10 * ( "ISBN" - TRUNCATE( "ISBN", - 1 ) ) ), 11 ) "ISBN10_Test" FROM "Media" ) AS "I_Test" WHERE "ID" = "a"."ID" AND "a"."ISBN" < 10000000000 ), 0 ) ) > 0 ) THEN 'ISBN-Number wrong' WHEN ( IFNULL( ( SELECT "ISBN" FROM "Media" WHERE "ID" = "a"."ID" ), - 1 ) = - 1 ) THEN '' ELSE 'ISBN-Number OK' END
Listbox_Title_MediaID_not_loan	ID	INTEGER	View_MediaID_Title_Author (Table)	ID
	ID_Title_Author	VARCHAR	View_MediaID_Title_Author (Table)	ID_Title_Author
Loan_not_locked	cur_Date			CURDATE( )
	FirstName	VARCHAR	Reader (Table)	FirstName
	ID	INTEGER	Reader (Table)	ID
	LastName	VARCHAR	Reader (Table)	LastName
	Lock	BOOLEAN	Reader (Table)	Lock
	Name			"LastName" || ', ' || "FirstName"
Media_Chart	Count	INTEGER		Count
	Media_ID	DOUBLE	SYSTEM_SUBQUERY	Media_ID
	Medium	VARCHAR		Medium
Media_Input_Search_Result	Category_ID	INTEGER	a	Category_ID
	Comment	VARCHAR	a	Comment
	Edition	VARCHAR	a	Edition
	ID	INTEGER	a	ID
	ISBN	NUMERIC	a	ISBN
	ISBN_Test			( SELECT "Test" FROM "ISBN_Test" WHERE "ID" = "a"."ID" )
	Mediastyle_ID	INTEGER	a	Mediastyle_ID
	Picture	VARBINARY	a	Picture
	Price	NUMERIC	a	Price
	Pub_Year	SMALLINT	a	Pub_Year
	Publisher_ID	INTEGER	a	Publisher_ID
	Title	VARCHAR	a	Title
	Town_ID	INTEGER	a	Town_ID
Media_Loan_Balance_Time	BalanceTime			( SELECT "Mediastyle"."Loantime" FROM "Mediastyle", "Media" WHERE "Media"."Mediastyle_ID" = "Mediastyle"."ID" AND ( "a"."Media_ID" = "Media"."ID" OR "Media"."ID" = TRUNCATE( "a"."Media_ID_BC", - 1 ) / 10 ) ) + IFNULL( "Extension", 0 ) * ( SELECT "ExtensionDays" FROM "Preferences" ) - DATEDIFF( 'dd', "Loan_Date", CURDATE( ) )
	Extension	TINYINT	a	Extension
	ID	INTEGER	a	ID
	Loan_Date	DATE	a	Loan_Date
	LoanDays			DATEDIFF( 'dd', "Loan_Date", CURDATE( ) )
	Media_ID			IFNULL( "Media_ID", TRUNCATE( "Media_ID_BC", - 1 ) / 10 )
	Medium			( SELECT "ID_Title_Author" FROM "View_MediaID_Title_Author" WHERE "ID" = "a"."Media_ID" OR "ID" = TRUNCATE( "a"."Media_ID_BC", - 1 ) / 10 )
	prolonged_for			IFNULL( "Extension", 0 ) * ( SELECT "ExtensionDays" FROM "Preferences" )
	Reader_ID	INTEGER	a	Reader_ID
	Return_Date	DATE	a	Return_Date
Media_Loan_Balance_Time_Recall	BalanceTime			( SELECT "Mediastyle"."Loantime" FROM "Mediastyle", "Media" WHERE "Media"."Mediastyle_ID" = "Mediastyle"."ID" AND ( "a"."Media_ID" = "Media"."ID" OR "Media"."ID" = TRUNCATE( "a"."Media_ID_BC", - 1 ) / 10 ) ) + IFNULL( "Extension", 0 ) * ( SELECT "ExtensionDays" FROM "Preferences" ) - DATEDIFF( 'dd', "Loan_Date", CURDATE( ) )
	Extension	TINYINT	a	Extension
	ID	INTEGER	a	ID
	ID_Title_Author	VARCHAR	View_MediaID_Title_Author (Table)	ID_Title_Author
	Loan_Date	DATE	a	Loan_Date
	LoanDays			DATEDIFF( 'dd', "Loan_Date", CURDATE( ) )
	Media_ID			IFNULL( "Media_ID", TRUNCATE( "Media_ID_BC", - 1 ) / 10 )
	prolonged_for			IFNULL( "Extension", 0 ) * ( SELECT "ExtensionDays" FROM "Preferences" )
	Reader_ID	INTEGER	a	Reader_ID
	Return_Date	DATE	a	Return_Date
Media_Recall_Reader	FirstName	VARCHAR	Reader (Table)	FirstName
	ID	INTEGER	Reader (Table)	ID
	LastName	VARCHAR	Reader (Table)	LastName
	Name			"Reader"."LastName" || ', ' || "Reader"."FirstName"
Reader_Input_Filter	FirstName	VARCHAR	a	FirstName
	Formheader			'Current record of ' || "LastName" || ', ' || "FirstName"
	Gender_ID	TINYINT	a	Gender_ID
	ID	INTEGER	a	ID
	LastName	VARCHAR	a	LastName
	Lock	BOOLEAN	a	Lock
	Name			"LastName" || ', ' || "FirstName" || CASEWHEN( ( SELECT "ID" FROM "Loan_not_locked" WHERE "ID" = "a"."ID" ) = "a"."ID", '', ' - Loan temporary locked!' )
Recall_Recallnumber	Date	DATE	a	Date
	ID	INTEGER	a	ID
	Loan_ID	INTEGER	a	Loan_ID
	Recallnumber			( SELECT COUNT( "Loan_ID" ) FROM "Recall" WHERE "Loan_ID" = "a"."Loan_ID" AND "Date" <= "a"."Date" )