- 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:
- Variable Scoping and Nested WITH ... END WITH Commands
/documentation/pages/Guides/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.
- Alpha Five V11
/documentation/pages/Index/Alpha Five V11.xml
Page links and information relating to A5 V11.
- 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.
- 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.
- 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". :-)
- SQL::Connection::LastInsertedIdentity Function
/documentation/pages/Ref/Api/Namespace/SQL/Connection/SQL Connection LastInsertedIdentity Function.xml
Returns the last inserted identity for a specific table (where possible) after executing an INSERT statement.
- 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).
- 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. This tutorial is written for Alpha Anywhere 4.4.3.
- Using Reports Created in SQL Server Reporting Services in an Alpha Anywhere Project
/documentation/pages/Guides/Report/SQL Server Reporting Services/index.xml
Many organizations use SQL Server Reporting Services (SSRS) and have a number of reports that were developed in SSRS. Using these reports in an Alpha Anywhere application is now possible using the SSRS integration features in Alpha Anywhere.