- 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.
- Hide Grid Part Options Properties
/pages/Guides/Mobile and Web Components/Grid/The Search Part/Search Properties/HideGridPartOptions.xml
Hide Grid Part Options Properties
- Property-Grid Style Dialog
/pages/Guides/Desktop/Xdialog/Property-Grid Style Dialog.xml
To create a property-grid style Xdialog.
- 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.
- 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:
- Record Navigator and Grid Toolbar
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Record Navigator and Grid Toolbar/index.xml
The Record Navigator lets you design how users to move through the records shown in your application. It also lets you change the appearance of the navigation part of your grid. If you want your record navigator to take the form of a tree-control there is a section in the properties for this here. Included in the Record Navigator properties is the Help Window property. This will allow you to build Help for your application, check out this page to see more information on building a Help system.
- Grid Fields
A rundown of options for creating and manipulating grid fields in the Grid Component builder.
- 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.
- Filtering a Grid with a Session Variable
/pages/Guides/Mobile and Web Components/Grid/Introducing the Grid Builder/Tutorials/Filtering/Filtering a Grid with a Session Variable.xml
How to filter the contents of a list based on the user's ID or another value.