- How to Export Selected Records to Excel in a Grid Component with a Checkbox Selector
/documentation/pages/HowTo/Grid/Export Checked Records to Excel.xml
Individual rows in a Grid Component can be exported to an Excel file using the Checkbox Selector Column to filter the Grid Component before performing the export.
- Moving an Access Application to the Web with Alpha Five
/documentation/pages/Server/Guide/Design/View/Database/Access to Alpha.xml
In this white paper, you will learn how to move a Microsoft Access desktop application to the Web with Alpha Five. You'll see how easy it can be, and when you're done you'll understand the process well enough to undertake it yourself.
- Getting the Value of an Auto-Increment Field
/documentation/pages/Server/Reference/Design/Data/SQL/Getting the Value of an Auto-Increment Field.xml
Say you inserted a new record into the customer table, and did not assign a value to the customer_id field, because this field is an auto-increment field. In many applications, after a record is inserted, it will be important to know what value the database engine assigned to the auto-increment field (note that a table can only have a single auto-increment field). The technique used to find the value of the auto-increment field varies depending on the type of back-end database that you are using. In the following example, we use a technique that works with SQL Server, Access, and MySQL. It may also work with some other databases, but certainly will not work will all databases. You will need to refer to the documentation for your database to see what method they use.
- Grid Component - Opening a UX from a Button on a Grid and Passing Information Into the UX
/documentation/pages/Server/Guide/Design/View/Grid/Opening a UX from a Button on a Grid and Passing Information Into the UX.xml
- 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.
- How to set the Background of an Ink Control
/documentation/pages/HowTo/UX/Set Ink Control Background.xml
You can set the background image shown in the ink control to anything you want - either by specifying the URL or the base64 encoded data for an image.
- Making a Field Read Only
/documentation/pages/Desktop/Reference/Design/Data/FieldRules/Making a Field Read Only.xml
There are several techniques for preventing a user from entering or editing a field on a form.
- How to Filter a Grid on the Selected Rows in a List Control
/documentation/pages/HowTo/Grid/Filter Grid With Selected List Rows.xml
Argument arrays, combined with the SQL IN clause, are a powerful way to filter records shown in a Grid component.
- How the Grid Was Configured in Video GM12
/documentation/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Alternate Views/Google Maps - Alternate Views/How the Grid Was Configured in Video.xml
A guide to configuring the video GM12 on how to use a Grid to implement a typical 'Store Finder' application.
- How to use the Next and Previous Buttons to Navigate the Controls in the Active Panel in an iOS Application
/documentation/pages/HowTo/PhoneGap/Use Next and Previous Buttons to Navigate Controls in Active Panel.xml
The native iOS keyboard has a next and previous button that can be used to navigate input controls on the screen. These buttons can be used with Alpha Anywhere application to navigate controls in the active Panel, however a little work is required to make sure the next or previous buttons do not try to navigate to a control that is on a panel that is not visible.