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.
How to Use User-Defined Scalar Functions in Oracle and SQL Server
/documentation/pages/HowTo/Databases/Call User Defined Scalar Functions in SQL Server Oracle.xml
User-defined scalar functions in Oracle and SQL Server can be called from Alpha Anywhere.
Alpha Five V11
/documentation/pages/Index/Alpha Five V11.xml
Page links and information relating to A5 V11.
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.
SQL::Connection::LastInsertedIdentity Function
/documentation/pages/Ref/Api/Namespace/SQL/Connection/SQL Connection LastInsertedIdentity Function.xml
Get the identity value from the last insert for the current session.
SQL::Connection::GenerateLastInsertedIdentityStatement Function
/documentation/pages/Ref/Api/Namespace/SQL/Connection/SQL Connection GenerateLastInsertedIdentityStatement Function.xml
Generate a SQL statement to retrieve the identity from the last insert statement (may be specific to the table passed in).
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". :-)
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.
Setting the Text and Value Properties of Items in a Choice List Array
/documentation/pages/Guides/Desktop/Xdialog/Controls/Setting the Text and Value Properties of Items in a Choice List Array.xml
The user defined choices displayed by a combo box, radio button, list box etc. can be read and set by reading or setting the text and value properties of the choice list array. The text property controls what is displayed on the form. The value property controls what value is written to the field when an item is selected.
Server Programming Functions and Methods
/documentation/pages/Server/Guide/Design/View/Grid/Server Programming Functions and Methods.xml
A list of server programming functions, including descriptions of functions and methods that have been removed or deprecated.