Alpha Five V11
/documentation/pages/Index/Alpha Five V11.xml
Page links and information relating to A5 V11.
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". :-)
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
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.
Server Starts in Demo Mode
/documentation/pages/Troubleshooting/Web Server/Server Starts in Demo Mode.xml
The Alpha Anywhere Application Server will start in demo mode if it cannot activate the product.
Server-side In-line and Conditional Style
/documentation/pages/Guides/Web Components/UX Components/UX Controls/Data Controls/List/List Builder/Fields/Server-side In-line and Conditional Style.xml
Conditional style for a field in a List control
Server-side In-line and Conditional Style
/documentation/pages/Guides/Web Components/UX Components/UX Controls/Control Properties/Data Control Properties/List Properties/List properties/Fields/Server-side In-line and Conditional Style.xml
Conditional style for a field in a List control
AlphaDAO - Stored Procedures and Output Arguments on the SQL Server
/documentation/pages/Guides/SQL/Native Driver/Stored Procedures/AlphaDAO - Stored Procedures and Output Arguments on the SQL Server.xml
If you have a SQL server stored procedure that sets the value of an output argument, reading the value in the output argument, after the stored procedure has executed can be tricky. That's because you have to ensure that you first loop through all of the result sets that are returned by the stored procedure before reading the output arguments.
Using SQL Tables in Web Security
/documentation/pages/Guides/Security Framework/Using SQL Tables in Web Security.xml
SQL tables can be used with the web security tables through the use of active link tables. The web security code supports active link tables but does not actually use the active link table. Instead, it just creates appropriate SQL statements based on the table definitions and accesses the SQL tables directly. Therefore the speed running against SQL tables is approximately the same as against DBF tables and may actually be faster if there are a large number of users.
Controlling Insertion Point and Selected Text in a Text Object
/documentation/pages/Guides/Desktop/Xdialog/Controlling Insertion Point and Selected Text in a Text Object.xml
This example shows how you can control the insertion point and selected text in a text control on an Xdialog box. Normally, when you place a text control on an Xdialog box, you bind the control to a character variable. For example: