- 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 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.
- Connecting to SQL Databases
Defining connection strings, and instructions for connecting to specific databases.
- 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 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 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 Salesforce
- 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 Alpha Anywhere.
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.
- NoSQL Databases
/documentation/pages/Guides/Databases/Working with NoSQL Databases/index.xml
Learn how to use the MongoDB and CouchDB APIs in Xbasic.