- Refresh Shadow Database
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Database/Refresh Shadow Database.xml
The Refresh Shadow Database action refreshes the current database if it is a shadow database, otherwise no action will occur.
- Cannot Refresh Database Problem
/pages/Guides/Desktop/Design/View/Database/Cannot Refresh Database Problem.xml
When Alpha Anywhere is refreshing a shadow database, it creates a file named after your database (.ADB file) by appending "LOCK" to the filename.
- Copying a Database Design
/pages/Desktop/Reference/Design/View/Database/Copying a Database Design.xml
To copy a database design to a new location, you need to avoid copying any test data that the design contains. You should copy all files except :
- SQL Database Snapshots
/pages/Guides/Databases/Working with SQL/Create Snapshots/SQL Database Snapshots.xml
This article discusses the SQL Snapshot objects in Alpha Anywhere. Snapshots store database definitions and data in a single object that can be created from a live database, persisted to and read back from XML, and can be used to create or re-load a database.
- Supported Database Products
/pages/Server/Reference/Design/Data/SQL/AlphaDAO Reference (SQL)/Supported Database Products.xml
With Alpha Anywhere data objects you can store and access data in a variety of available databases. These include relational database products that support SQL (Structured Query Language) as well as key/value and document databases.
- Configuring the Northwind Database
The Northwind database ships with Alpha Anywhere. These step-by-step tutorials describe how to setup Northwind as an Access, MySQL, or SQL Server database.
- Refresh Database Schema
/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Data Source/Refresh Database Schema/index.xml
Means of refreshing the database schema every time the list builder is opened
- Backup Database Dialog Box
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Database/Backup Database Dialog Box.xml
The Backup Database Dialog Box action displays the Backup Database dialog box. This is the same as selecting the Table/Sets tab of the Control Panel, then clicking Tools > Backup/Restore Database > Backup Database....
- Open Another Database
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Database/Open Another Database.xml
The Open Another Database action closes the current database and opens another. You can specify the database to open ahead of time, or prompt the user at run-time.
- Database Utility Help Pages
/pages/Index/Database Utility Help Pages.xml
Page links relating to database utilities.