- Working with SQL
/documentation/pages/Guides/Databases/Working with SQL/index.xml
Tips on creating databases, creating SQL queries using Alpha Anywhere's Portable SQL Syntax, using the SQL command window, and more.
- Working with Pointer Arrays
/documentation/pages/Guides/Desktop/Xdialog/Working with Pointer Arrays.xml
Pointer arrays (also called "property arrays") allow you to represent "multi-columned" data in an array. For example, for a customer, you have information about the customer's name, address, phone number etc.
- Working with Reports
/documentation/pages/Guides/Report/Getting Started/Working with Reports.xml
Reports, Letters, and Labels are Alpha Anywhere layouts for data output. Learn how to create reports in this guide.
- Working with SQL Reports
/documentation/pages/Guides/Report/Getting Started/Working with SQL Reports.xml
There are 2 different approaches to building a SQL Report.
- Working with Records
/documentation/pages/Desktop/Tutorial/Design/View/Database/Working with Records.xml
In this lesson, you learn how to view and enter data in Alpha Anywhere, and how to create, change, save, and delete table records.
- Working with RTF Data
/documentation/pages/Guides/Desktop/Design/View/RTF/Working with RTF Data.xml
Using Xbasic, you can manipulate data in variables and in RTF memo fields. In order to manipulate a RTF memo field, you need to create a temporary RTF object, manipulate its contents, and then put the contents of the temporary RTF object back into the RTF memo field.
The RTF.CREATE() method is used to create a RTF object. Refer to RTF Functions and Methods for more information.
- Working with Workspaces
/documentation/pages/Guides/Desktop/Design/View/Workspace/Working with Databases.xml
Tables, sets, and workspaces are the primary structures for storing data in an Alpha Anywhere desktop applications.
Your workspace files keep track of all of the tables, sets, toolbars, forms, and such, used for managing information. When you open an existing workspace, Alpha Anywhere displays the objects (tables, forms, etc.) that make up the workspace in the Control Panel. With Alpha Anywhere, you work with one workspace at a time.
- Working with Version Control
/documentation/pages/Server/Guide/Design/View/Web Component Controls/Working with Version Control.xml
It easy to integrate your Alpha Anywhere coding with external version control systems.
Most version control systems depend on storing the small differences between successive versions of text files for efficient storage. Most Alpha Anywhere artifacts are normally stored in a binary database or a binary file for efficient loading and saving. This has historically presented an "impedance mismatch" between Alpha Anywhere code and version control systems. To address this, we have introduced the option to keep a project's code in an external file system.
- Working with Salesforce
- Connecting to Oracle
/documentation/pages/Guides/Databases/Connecting/Connecting to Oracle.xml
A guide to using auto-increment in Oracle.