Grid Component Capabilities
/documentation/pages/Server/Guide/Design/View/Grid/Grid Component Capabilities.xml
Web publishing applications only. A grid component displays reads from and writes to your database and displays the data in a web page. The Grid Builder is a genie that you use to create grid components. The HTML Editor allows you to place grid components into A5W pages (an A5W page is a hybrid HTML/Xbasic page that is processed by the Application Server ). Grids have many optional capabilities that you can enable or disable through menus. Many properties of a new grid component have default properties. If you wish, you can set different default property values.
How to Call a UX Component from a Grid and Pass Information from the UX Component Back into the Grid
/documentation/pages/HowTo/Grid/Calling a UX Component from a Grid and Pass Information from the Dialog Back to the Grid.xml
Steps and examples on how to do this are described in this page.
How to Define Dynamic Content for a Tab/Accordion Control Pane
/documentation/pages/HowTo/Grid/Defining Dynamic Content for a Tab Accordion Control Pane.xml
Advanced uses might want to use the Tab and Accordion control's onDynamicLoad property to define a Javascript event that will fire when the particular tab/accordion pane gets focus for the first time. This allows you to load dynamic content into the tab/accordion pane only when the pane is visited. If the pane is never visited, then you do not waste time and server resources computing content that will not be seen. As the image below shows, the third pane (labeled 'DynamicLoad') does not have any controls in it. When the user visits the tab pane, the onDynamicLoad function will fire and it will be set the tab pane content.
Grid Component SQL Database Credentials
/documentation/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component SQL Database Credentials.xml
By default all users who use a Grid component connect to the SQL database using the same credentials. These credentials are defined in the a5_application.a5i file which is automatically published when your application is published. The a5_application.a5i file defines how each named connection string in your application should be resolved at runtime.
Creating a Grid Component - Tutorial
/documentation/pages/Guides/Mobile and Web Components/Grid/Introducing the Grid Builder/Tutorials/Creating a Grid Component - Tutorial.xml
Covers a range of topics including selecting a database, creating a grid component, selecting data to use and display in the component, and how to view the component in a browser.
Grid Component Search Part
/documentation/pages/Guides/Mobile and Web Components/Grid/The Search Part/Grid Component Search Part.xml
A guide to all of the options available in the grid component search part.
Open a UX component to Edit Current Record in Grid, or add a new Record
/documentation/pages/Ref/Action Javascript/Open a UX component to Edit Current Record in Grid, or add a new Record.xml
Open an UX component in a pop-up window, or in a DIV on the current page, to edit the current row in a Grid component or to enter a new record. (Only new Ajax Components can be opened. Old Dialogs in V10 and earlier are not supported.)
Grid Component - SQL Database Errors
/documentation/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component SQL Database Errors.xml
You can now customize the text that is displayed when the SQL Database reports an Insert, Update or Delete error. By default, Alpha Anywhere displays this text for an Update, Delete or Insert Error:
Opening a Page with a Grid Component and Showing Selected Records
/documentation/pages/Server/Guide/Design/View/Grid/Opening a Page with a Grid Component and Showing Selected Records.xml
A common requirement when building a grid is to have a hyperlink field in the grid that, when clicked, will open a second page. The second page contains a grid that is filtered based on parameters from the first page. These examples show how to do this. The URL that opens the second page has query parameters that contain one or more of the _filter, _order, and _link keywords. These keywords allow you to specify a filter, order and/or linking parameters for the grid in the target page.
Ordering Lookup Entries - Grid Component
/documentation/pages/Server/Guide/Design/View/Grid/Ordering Lookup Entries - Grid Component.xml
Often you will want to display a list of values selected from a table. It is often desirable to specifically order these entries, instead of allowing them to display in record order or alphabetically. Here is a technique for solving this problem. This example uses a drop down list box on a dialog component, but the technique works equally well with a list box on a grid component.