- Web Grid Enhancements V11
/pages/Index/Web Grid Enhancements V11.html
- 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.
- SQL Native Syntax Dialog Box
/pages/Guides/Desktop/Design/Data/SQL/SQL Native Syntax Dialog Box.xml
The SQL Native Syntax dialog allows you to see the Portable SQL that you have created in the SQL Genie and the corresponding SQL in the native dialect of any of these databases.
- Web Grid Videos
/pages/Server/Guide/Design/View/Grid/Web Grid/Web Grid Videos.xml
Associate an animation effect with each show/hide expression you define.
- Turn Ajax On/Off in Grid Components
/pages/Guides/Workspaces/Bulk Operations/turn ajax on off for grids.xml
Bulk operation to enable or disable Ajax in all Grid Components. This operation should only be used to upgrade Grid Components built using Alpha Five Version 9 or older.
- 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:
- 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.
- SQL::Connection::GenerateNativeTableName Function
Generate a formatted table name suitable for a SQL query in using the current syntax.
- SQL::Connection::GenerateNativeColumnName Function
Generate a formatted column name suitable for a SQL query in using the current syntax.