- Web Grid Enhancements V11
/pages/Index/Web Grid Enhancements V11.html
- 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.
- 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:
- Opening a Page with a Grid Component and Showing Selected Records
/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.
- Show query statements on Ajax callbacks
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Advanced/showquerystatementsonajaxcallbacks.xml
Enables display of SQL Select statements used to populate the Grid Component when an Ajax Callback is made.
- How to Dynamically Construct SQL Statements
/pages/HowTo/Databases/Dynamically Construct SQL Statements.xml
This interactive session demonstrates how you can programmatically modify SQL statements from Xbasic.
- What's New in Version 11
/pages/Index/What's New in Version 11.xml
Welcome to Alpha Five Version 11! If you thought we added a ton of functionality in Versions 10 and 10.5 plus the Feature Packs, you may have to recalibrate your notion of what defines a "ton of functionality".
- 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.
- SQL::Query Object
SQL::Query object methods and related enumerations and objects.