Power Search for Grid using a Dialog Component
/documentation/pages/Server/Guide/Design/View/Grid/Power Search for Grid using a Dialog Component.xml
Requires the Dialog Component - Power Search for an Embedded Grid Component feature pack, included in subscription
Execute UPDATE Query on a SQL Database
/documentation/pages/Guides/Desktop/Design/Data/SQL/Execute UPDATE Query on a SQL Database.xml
The Execute UPDATE Query on a SQL Database action allows you to modify one or more records in a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.
Filtering a Grid with a UX Component
/documentation/pages/Guides/Mobile and Web Components/Grid/Introducing the Grid Builder/Tutorials/Filtering/Filtering a Grid with a Dialog.xml
One of the most common tasks a web application can perform is to collect the values of one or more variables, then use this data to display a filtered view of a table.
How to Use Custom Controls in a Grid Component
/documentation/pages/HowTo/Grid/Using Custom Controls in a Grid Component.xml
This topic discusses an advanced use of a Custom Control in a Grid component.
Creating a Property Grid for a User-defined Component
/documentation/pages/Guides/Mobile and Web Components/Custom/Creating a Property Grid for a User-defined Component.xml
One way to create a Property Grid for a User-defined Component is to use the Property Grid builder in Action Scripting to generate the markup. This is invoked by creating a New Script (using Action Scripting), adding a new action, and selecting Xdialog Windows|Display an Xdialog Box.
Office Example: Spreadsheet from SQL query
/documentation/pages/Ref/Api/Namespace/Office/Examples/SpreadsheetFromSQLQuery.xml
An example of a simple spreadsheet from a SQL Query using Alpha's Northwind.mdb.
Grid Component Properties and Methods
/documentation/pages/Ref/Client_Api/Grid/index.xml
Properties and methods that can be used on the client side to automate grid components.
Execute SELECT Query on a SQL Database
/documentation/pages/Guides/Desktop/Design/Data/SQL/Execute SELECT Query on a SQL Database.xml
The Execute SELECT Query on a SQL Database action allows you to execute a SQL SELECT statement (a query) on a remote SQL database (or Excel spreadsheet) to retrieve one or more record(s). Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.
Execute DELETE Query on a SQL Database
/documentation/pages/Guides/Desktop/Design/Data/SQL/Execute DELETE Query on a SQL Database.xml
The Execute DELETE Query on a SQL Database action allows you to delete one or more records from a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.
UX and Grid Component - Javascript Confirmation Windows - Title Direction
/documentation/pages/Guides/Mobile and Web Components/UX/Code/Javascript In UX Components/Javascript Confirmation Windows - Title Direction.xml
By default, all confirmation dialogs show the title on the left and the close icon on the right. For right to left languages, you might want to change this. To do so, put the following Javascript in the Grid or UX onRenderComplete client-side event: