- Filtering a Grid with a UX Component
/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.
- TGRDL_CUST Tabbed GridLinker Component
/pages/Obsolete/Alpha Sports/Components/TGRDL_CUST Tabbed GridLinker Component.xml
Reviews and edits customer records and customer sales history.
- Power Search for Grid using a Dialog Component
/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
- How to Use Custom Controls in a Grid Component
/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.
- Office Example: Spreadsheet from SQL query
An example of a simple spreadsheet from a SQL Query using Alpha's Northwind.mdb.
- Grid Component Properties and Methods
Properties and methods that can be used on the client side to automate grid components.
- Execute SELECT Query on a SQL Database
/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.
- Creating a Property Grid for a User-defined Component
/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.
- Execute DELETE Query on a SQL Database
/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.
- Command Statements
The Xbasic command statements determine the structure and flow of execution in a script. For example, the if .. then statement is used to perform actions conditionally. The following script will make the computer beep if the supplied logical expression, x < 5, evaluates to .T. (TRUE):