The Alpha Anywhere Enterprise edition provides Xbasic program access to SQL databases such as Microsoft SQL Server, Oracle, MySQL as well as Microsoft Access. This functionality extends the familiar Alpha Anywhere database features that previously supported only .DBF files. AlphaDAO provides the following SQL objects. Each object has properties and methods.

Includes: What is AlphaDAO?, terminology, the AlphaDAO object, and creating an object,

Methods for Layouts objects, including Control, Label, Letter, and Report objects.

Methods for System objects, including Addin, FILE, FileFind, OLE, Registry, Sockets, Thread, Trace, Exe, and Module objects.

Utility objects - ImageName object, ImageResource object, ImageViewer object, and StringScanner object.

Alpha Anywhere Data Access Objects (AlphaDAO) let your web or mobile application communicate with a SQL Database. Learn how to create an AlphaDAO connection string to an Access, MySQL, or SQL Server database using the Northwind database that ships with Alpha Anywhere.

Methods for Operation objects, including the Append, Copy, Export, Import, Join, Mark, and Post object.

Dictionary, Field, index, Query, Set, and Table objects. Also methods for Database operations.

The Refresh Object(s) action refreshes the displayed contents of one or more objects.

Before you can change an object's properties, move, resize, or delete it, you must first select it. You select a single object by clicking on it with the Selection tool from the toolbar; you select multiple objects by either holding down the SHIFT key while clicking on each object with the selection tool, or by using the selection tool to draw a rectangle (lasso) around the objects to be selected.