project. 5. Click Save. 28 Chapter 5 - Data Source About Data Source Data sources reference tables in your connections or data in files/ODBC sources, and can select data from tables on different Custom-Sorted Field to get started. 57 2. In the pop-up window, enter the Target Field Name. 3. [Reference Field] Choose the field which the sort order of the target field will be based on. 4. [Custom] Return the average of all the values. Null values are ignored. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not

project. 5. Click Save. 27 Chapter 5 - Data Source About Data Source Data sources reference tables in your connections or data in files/ODBC sources, and can select data from tables on different Custom-Sorted Field to get started. 2. In the pop-up window, enter the Target Field Name. 3. [Reference Field] Choose the field which the sort order of the target field will be based on. 4. [Custom] Return the average of all the values. Null values are ignored. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not

project. 5. Click Save. 27 Chapter 5 - Data Source About Data Source Data sources reference tables in your connections or data in files/ODBC sources, and can select data from tables on different Custom-Sorted Field to get started. 2. In the pop-up window, enter the Target Field Name. 3. [Reference Field] Choose the field which the sort order of the target field will be based on. 4. [Custom Return the average of all the values. Null values are ignored. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not

space and improve I/O efficiency. Repair Table Repair the possibly corrupted table. Get Rows Count Count the number of rows in the table. Tablespace Option Description Set Active Mark an InnoDB contents of the table. Reindex Table Delete and recreate all indexes of the table. Get Rows Count Count the number of rows in the table. Index Option Description Reindex Delete and recreate tool for letting you to get the available value from the reference table in an easy way. It allows you to show additional records from the reference table and search for particular records. To include

and improve I/O efficiency. Repair Tables Repair the possibly corrupted table. Get Rows Count Count the number of rows in the table. Tablespace Option Description Set Active Mark an InnoDB contents of the table. Reindex Tables Delete and recreate all indexes of the table. Get Rows Count Count the number of rows in the table. Index Option Description Reindex Delete and recreate tool for letting you to get the available value from the reference table in an easy way. It allows you to show additional records from the reference table and search for particular records. To include

space and improve I/O efficiency. Repair Tables Repair the possibly corrupted table. Get Rows Count Count the number of rows in the table. Tablespace Option Description Set Active Mark an InnoDB contents of the table. Reindex Tables Delete and recreate all indexes of the table. Get Rows Count Count the number of rows in the table. Index Option Description Reindex Delete and recreate tool for letting you to get the available value from the reference table in an easy way. It allows you to show additional records from the reference table and search for particular records. To include

Editor General Show line number Display line numbers at the left side of the editor for easily reference. Use code folding Code folding allows codes to collapse as a block and only the first line displayed 78 Highlight the pair of braces when your cursor moves to either one brace for easily reference. Use syntax highlighting Syntax highlight helps viewing codes clearly. Codes are highlighted it will be predicted as a primary key)  suffix "num"  "qty", "number"  exactly "age", "count" DECIMAL(10,2)/decimal(10,2)/NUMBER/REAL/money  suffix "price", "cost", "salary" FLOAT/do

performance. Show Show line number Display line numbers at the left side of the editor for easily reference. Use code folding Code folding allows codes to collapse as a block and only the first line displayed highlighting Highlight the pair of braces when your cursor moves to either one brace for easily reference. Use syntax highlighting Syntax highlight helps viewing codes clearly. Codes are highlighted it will be predicted as a primary key)  suffix "num"  "qty", "number"  exactly "age", "count" DECIMAL(10,2)/decimal(10,2)/NUMBER/REAL/money  suffix "price", "cost", "salary" FLOAT/do