- Active-Link Tables
Active-Link tables allow you to work with data in SQL tables. An active-link table is a local Alpha Anywhere table that is dynamically populated with data from a remote SQL database. Any changes that you make to the local active-link table are immediately persisted (i.e. saved) to the remote database. This means that you can build Alpha Anywhere forms that update, insert and delete records in remote SQL tables. In addition, it means that you can use your knowledge of how to work with tables using Xbasic to manipulate data in remote SQL databases.
- Reports - Sets - Active Link Tables
/pages/Guides/Report/Creating Reports/Active Link Tables in Reports and Sets.xml
When you create a new Report, Label or Letter that is based on a Set that joins Active-Link tables, Alpha Anywhere analyzes the Set structure and the definition of each of the Active-Link tables to see if the Report could instead be based on a SQL Query.
- Optimized Active-Link Sets
/pages/Guides/Desktop/Design/Data/SQL/Optimized Active-Link Sets.xml
In Sets that are based on active-link tables, there are now dramatic performance improvements under certain conditions. The conditions under which you will see performance improvements are in Sets with one-to-one links, were the one-to-one links at a given level in the Set are based on the same SQL backend database.
- Encrypting Tables
Alpha Anywhere allows you to encrypt tables so that people who do not know the password cannot read them.
- Active Directory Integration
An overview of active directory authentication and authorization with the Alpha Anywhere IIS Application Server.
- Using SQL Tables in Web Security
/pages/Guides/Security Framework/Getting Started/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.
- Learning Xbasic - Using Xbasic with SQL Tables
/pages/Guides/Desktop/Design/Platform/Xbasic/Learning Xbasic - Using Xbasic with SQL Tables.xml
A tutorial about learning Xbasic. Includes a number of videos and procedural guides for working with Xbasic and sql tables.
- LINK Function
/pages/Ref/Api/Functions/Document Types/DBF/Set Functions/LINK Function.xml
Returns the linking key given the name of a child table.
- Mapped Tables
Alpha Anywhere now allows you to create 'mapped' tables. A mapped table is a virtual table that displays data from one or more physical tables. The mapped table can include all, or a subset of, the field fields in the physical tables that it maps. It can also include calculated columns. Once you have created a mapped table, it appears in the Tables tab of the Control Panel just like any other table. You can create Forms, Reports, Labels, Letters and Operations for mapped tables just as you would for physical tables. Mapped tables can be read-only, or updateable, depending on how they are defined.
- Link Properties
/pages/Guides/Mobile and Web Components/Grid/Grid Fields/Grid Field Properties/Control Properties/Link Properties.xml
An essential decision about a link control is what it will display. The options are: Value in field, Value from other field(s), Static text, Static image, Image in another control