- Dynamic Images and Image Sequences
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Alternate Views/Google Maps - Alternate Views/Dynamic Images and Image Sequences.xml
When you place a marker on a Google Map, you have full control over the icon that is used. You can specify an expression that evaluates to the icon name to use for the marker. Or, you can specify an Xbasic function that will get called for each row in the Grid. The function can compute the marker icon based on the data in the current Grid row.
- Dynamic Image Properties
/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Fields/Dynamic Image Properties/index.xml
The 'Add Item' button has an option to add a Dynamic Image control to the List Builder's 'Fields' pane.
This in turn opens the Dynamic Image Properties.
- Open a Grid component
Opens a grid component in a pop-up window, or in a DIV on the current page.
This requires first defining a grid component.
- Grid Components - Sequences
/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Components Sequences.xml
The Grid Component now fully supports the use of 'sequences'. Some databases, such as Oracle, implement auto-increment fields through the use of 'sequences'. A 'sequence' is an object that is used to get the next number for an auto-increment field when a record is inserted. In order to use a sequence to generate the ID values for an auto-increment field, you need to tell the Grid component what the name is of the sequence to use.
- 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.
- 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 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.
- 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:
- 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.