- Group Breaks
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Group Breaks/index.xml
When a Grid is rendered it can be useful to break the Grid up into logical sections by inserting Group Breaks with group headers and/or footers into the Grid. If you had a number of customers across the US that you wanted to visually group by state, for example, a group break could help you create state headers within your grid. This section contains all the properties that allow you to define group breaks for different grids.
- How to Collapse a Group in a Grid Component
/pages/HowTo/Grid/Collapse Grid Group.xml
Group breaks are a useful way to organize records in a Grid Component. You can add special directives that enable a user to expand or collapse records in a group in a Grid component.
- Server-side Group Breaks
/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Data Source/Server-side Group Breaks/index.xml
Server-side Group Breaks can be used with different data source types. Group breaks take the form of headers over blocks of data that share something in common.
These should not to be confused with titles. Whereas a title is inserted above a block of data, group breaks draw their definition from the data itself. Alpha Anywhere
contains a number of properties that help in determining how the group break should be formed from existing data, whether or not it should be used to sort data, and means of changing
group break headers. These properties are listed here.
- The Grid Component
/pages/Guides/Mobile and Web Components/Grid/index.xml
Guides on how to use the grid builder, grid properties and features, example pages, and more.
- Grid Component Capabilities
/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.
- Grid Component SQL Database Credentials
/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
/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
/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.
- Ordering Lookup Entries - Grid Component
/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.
- Grid Component - SQL Database Errors
/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: