Copying a Database Design
/documentation/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 :
Copying a Report to Another Database
/documentation/pages/Guides/Report/Managing Reports/Copying a Report to Another Database.xml
If you would like to copy a report to another database, it is important to understand that a report is not attached to a database. It is attached to a table. The source and destination databases must have tables with the same field names and definitions.
Copying Selected Text from a Memo Control
/documentation/pages/Guides/Desktop/Xdialog/Controls/Copying Selected Text from a Memo Control.xml
The following example shows how to copy selected text from a memo control. The script then pastes the copied text into a different text control on the same form.
Working with a Browse in Design Mode
/documentation/pages/Guides/Desktop/Design/View/Browse/Working with a Browse in Design Mode.xml
A number of short procedures for working with a browse. Topics include changing a browse's dimensions, removing fields from a browse, and adding fields to a browse
How to Design a Custom Menu
/documentation/pages/Guides/Desktop/Design/View/Form/Design a Custom Menu.xml
Covers designing a custom menu, inserting an item in a menu, new menu entries, pre-defined menu items, etc..
Create a SQL Database
/documentation/pages/Guides/Databases/Connecting/Create a SQL Database.xml
Covers the simple step of building a new SQL Connection String for AlphaDAO
Connecting to a SQL Database
/documentation/pages/Guides/Databases/Connecting/Connecting to a SQL Database.xml
How to define a connection to a SQL database, procedural steps included.
Alpha Anywhere File Types
/documentation/pages/Guides/Desktop/Design/Data/Set/Alpha Anywhere File Types.xml
If you look at an Alpha Anywhere database through Windows Explorer, you will see that there are many files that begin with each table's or set's name, but have different file extensions. The following table provides a cross reference to lists of functions and methods relevant to each file type.
Execute UPDATE Query on a SQL Database
/documentation/pages/Guides/Desktop/Design/Data/SQL/Execute UPDATE Query on a SQL Database.xml
The Execute UPDATE Query on a SQL Database action allows you to modify one or more records in a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.
Deleting Records in a Back-end Database
/documentation/pages/Guides/Desktop/Design/Data/SQL/Deleting Records in a Back-end Database.xml
To delete records into a back-end database, you use the SQL DELETE command. The general syntax of the DELETE command is: