Variable Scoping and Nested WITH ... END WITH Commands
/documentation/pages/Server/Guide/Design/Platform/Xbasic/Variable Scoping and Nested WITH __ELLIPSES__ END WITH Commands.xml
When you nest WITH ... END WITH commands, it is important to understand how Xbasic treats variables DIMmed in different name-spaces. If a WITH ... END WITH command is nested within another WITH ... END WITH construct, the inner name-space is called the child name-space and the outer name-space is the parent name-space. Any variable that is DIMmed in the parent name-space will be visible in the child name-space. Any variable that is DIMmed in the child name-space will not be visible in the parent name-space (unless the variable name is prefixed with the name-space name, as in: name-space.variable ). The following Xbasic script demonstrates this. In this script, "A" is the parent name-space and "B" is the child name-space. The variable, firstname is DIMmed in the parent name-space. It is therefore visible in the child name-space.
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.
Alpha Five V11
/documentation/pages/Index/Alpha Five V11.xml
Page links and information relating to A5 V11.
Getting Started With Alpha Anywhere - Build Your First Mobile App
/documentation/pages/GettingStarted/GettingStartedTutorials/Build a Mobile App/index.xml
Follow this step-by-step guide to your first Alpha Anywhere application to run in a mobile web environment.
What's New in Version 11
/documentation/pages/Index/What's New in Version 11.xml
Welcome to Alpha Five Version 11! If you thought we added a ton of functionality in Versions 10 and 10.5 plus the Feature Packs, you may have to recalibrate your notion of what defines a "ton of functionality". :-)
List Control Overview : Building Disconnected Applications
/documentation/pages/Guides/Web Components/UX Components/UX Controls/Data Controls/List/_Building Disconnected Applications/index.xml
The List Control is the fundamental building block for creating mobile applications with offline support. Interfaces for editing data via a Detail View and searching records with sophisitcated Search controls are also easily added and configured to work with the List Control. Fetching, editing, and synchronizing data are all handled by the List Control.
How to Dynamically Populate List Columns and Data
/documentation/pages/HowTo/List Control/Dynamically Populate List Control.xml
A List control can be dynamically repopulated with data from different tables.
Opening a Page with a Grid Component and Showing Selected Records
/documentation/pages/Server/Guide/Design/View/Grid/Opening a Page with a Grid Component and Showing Selected Records.xml
A common requirement when building a grid is to have a hyperlink field in the grid that, when clicked, will open a second page. The second page contains a grid that is filtered based on parameters from the first page. These examples show how to do this. The URL that opens the second page has query parameters that contain one or more of the _filter, _order, and _link keywords. These keywords allow you to specify a filter, order and/or linking parameters for the grid in the target page.
Finding and Replacing in Scripts and Functions
/documentation/pages/Desktop/Guide/Design/Platform/Xbasic Action Scripting/Finding and Replacing in Scripts and Functions.xml
The Edit > Find , Edit > Find and Replace , and Edit > Goto features let you search an entire script or just selected text. You can search forward or backward, for whole words, and with case sensitivity.
AlphaDAO - SQL Server - Identity Fields - Triggers
/documentation/pages/Server/Reference/Design/Data/SQL/AlphaDAO SQL Server Identity Fields Triggers Bug.xml
There is a bug in SQL Server when you get the value of the last inserted identity column value under the following situation. Say you have a table (called say, 'MasterTable'). 'MasterTable' has an identity column. 'MasterTable' also has an Insert Trigger which inserts a new record into a table (called say, 'ChildTable'). 'ChildTable' also has an identity column. When you insert a record into 'MasterTable', the following AlphaDAO command can be used to get the value of the last inserted identity column: .CallResult.LastInsertedIdentity