Difference between revisions of "Pages Files Tab"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (→The Pages Files Tab) |
||
| Line 14: | Line 14: | ||
==The Pages Files Tab== | ==The Pages Files Tab== | ||
| − | From the Pages Files Tab you can drag and drop tables and their | + | From the Pages Files Tab you can drag and drop tables and their columns into the Page Builder visual page designer to create automatically data-bound controls. |
| − | + | You can also carry out many database administration operations just like in the [[Data Files Tab]]. The Pages Files Tab displays a list of tables in the current database (and allows you to open a database if none is open), a list of the fields from the currently selected table and the attributes for the currently selected column. | |
===Databases=== | ===Databases=== | ||
| Line 30: | Line 30: | ||
</div> | </div> | ||
| − | === | + | ===Table Names=== |
By default, the '''Tables''' tab is displayed within the Pages Files Tab. Click on a table name in the '''Table Names''' panel to select it and display its columns and their attributes in the lower panels. | By default, the '''Tables''' tab is displayed within the Pages Files Tab. Click on a table name in the '''Table Names''' panel to select it and display its columns and their attributes in the lower panels. | ||
| Line 44: | Line 44: | ||
[[{{ns:file}}:pf_tab_tabs3.png|left|link={{filepath:pf_tab_tabs3.png}}|Pages Files Tab]] | [[{{ns:file}}:pf_tab_tabs3.png|left|link={{filepath:pf_tab_tabs3.png}}|Pages Files Tab]] | ||
<br clear=all> | <br clear=all> | ||
| + | |||
| + | ===Column Names=== | ||
| + | The middle panel in the '''Tables''' tab of the Pages Files Tab displays the columns from the currently selected table. Double-click on a column name to open it in the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|MODIFY A COLUMN dialog]] so you can modify its definition and/or attributes. | ||
| + | |||
| + | Hover the mouse over a column name row to display information about the column: | ||
| + | [[{{ns:file}}:pf_tab_cols.png|left|link={{filepath:pf_tab_cols.png}}|Pages Files Tab]] | ||
| + | <br clear=all> | ||
| + | |||
| + | You can also open the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|MODIFY A COLUMN dialog]] by clicking on '''Edit''' in the actionbar. | ||
| + | |||
| + | The actionbar also has buttons to add a '''New''' column (opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|CREATE A COLUMN dialog]]) or '''Delete''' the selected column: | ||
| + | [[{{ns:file}}:pf_tab_cols2.png|left|link={{filepath:pf_tab_cols2.png}}|Pages Files Tab]] | ||
| + | <br clear=all> | ||
| + | |||
| + | And from the '''Additional commands''' (cog) select '''Refresh''' to refresh the columns list: | ||
| + | [[{{ns:file}}:pf_tab_cols3.png|left|link={{filepath:pf_tab_cols3.png}}|Pages Files Tab]] | ||
| + | <br clear=all> | ||
| + | |||
| + | ===Column Attributes=== | ||
===Dock Tab=== | ===Dock Tab=== | ||
Revision as of 13:17, 18 December 2017
Under Construction
Contents
The App Inspector
The App Inspector is your best friend during development as it provides a complete overview of your App.
It is organized into Tabs. Each Tab is relevant to a particular workspace. You can double click a Tab to detach it into its own floating window.
Clicking the small icon on the far right of the App Inspector title bar will detach it into its own floating window.
Double clicking the window title bar when it is floating will attach it back into place.
The Pages Files Tab
From the Pages Files Tab you can drag and drop tables and their columns into the Page Builder visual page designer to create automatically data-bound controls.
You can also carry out many database administration operations just like in the Data Files Tab. The Pages Files Tab displays a list of tables in the current database (and allows you to open a database if none is open), a list of the fields from the currently selected table and the attributes for the currently selected column.
Databases
If you did not select a database when creating your App, you can open a database from the Databases tab within the Pages Files Tab.
If you select a database when creating your App then close the App without adding any data-bound sections or formitems, you will need to re-select the database to load it in the Pages Files Tab and associate it with your App.
Table Names
By default, the Tables tab is displayed within the Pages Files Tab. Click on a table name in the Table Names panel to select it and display its columns and their attributes in the lower panels.
Hover the mouse over a table name row to display information about the table:
From the actionbar you can add a New table (this will open the CREATE A TABLE dialog) or Delete the selected table:
And click the Additional commands (cog) then Refresh to refresh the tables list:
Column Names
The middle panel in the Tables tab of the Pages Files Tab displays the columns from the currently selected table. Double-click on a column name to open it in the MODIFY A COLUMN dialog so you can modify its definition and/or attributes.
Hover the mouse over a column name row to display information about the column:
You can also open the MODIFY A COLUMN dialog by clicking on Edit in the actionbar.
The actionbar also has buttons to add a New column (opens the CREATE A COLUMN dialog) or Delete the selected column:
And from the Additional commands (cog) select Refresh to refresh the columns list:
Column Attributes
Dock Tab
To dock the tab back in the App Inspector, click the [x] or double-click the window title bar.
