- List of orders for a customer (from the Northwind sample database)
/pages/Guides/Mobile and Web Components/UX/Controls/Data Controls/ViewBox/Sample ViewBoxes/List of orders for a customer Northwind.xml
Example showing a list of orders for a customer based on data in the Northwind sample database. Requires a named SQL connection string called 'northwind'.
- Advanced Record List - List Box Control Syntax
/pages/Ref/Desktop_Api/UI Functions/XDialog/Controls/Record List/Advanced Record List - List Box Control Syntax.xml
The Record List - List Box Control provides a dynamic view of selected records and fields from a table or set.
- Types of Field Rules
/pages/Guides/Desktop/Design/Data/FieldRules/Types of Field Rules.xml
The following list includes a brief description of each field rule in its own respective category.
- Overview of Layout Tools
/pages/Guides/Desktop/Design/View/Layout/Overview of Layout Tools.xml
Layouts are the primary means by which data is entered, viewed, and printed in Alpha Anywhere. There are five different kinds of layouts: Forms, Browses, Reports, Letters, and Labels. Layouts let you display and edit data.
- Automatic Recovery of Indexes
/pages/Guides/Desktop/Design/View/Database/Automatic Recovery of Indexes.xml
The following two scripts allow a user to take a snapshot of all of the indexes in all of the tables in their application, and then check the actual indexes against the index definitions stored in the snapshot.
Script 1 loops through all of the table in a database and stores the index definitions in a text file on disk. The text file is the same as the Database name but it has a ".TableInformation" extension. You would run Script 1 only once.
Script 2 retrieves the index definitions and checks the indexes in the tables against the saved index definitions.
- Number of "Layout" Columns
/pages/Guides/Mobile and Web Components/Grid/The Detail View/Detail View Properties/Other Customization/numberoflayoutcolumns.xml
Set the number of logical columns to display in the layout.
- Benefits of Viewing Xbasic
/pages/Guides/Desktop/Design/Platform/Xbasic/Benefits of Viewing Xbasic.xml
There are many benefits of displaying the Xbasic code for an operation. Inexperienced users who wish to learn about Xbasic can see how their operations are formed, and see the Xbasic syntax in action.
Intermediate and expert users can use the Xbasic generated by the Operation Builder as a starting point for an extended Xbasic script. Used this way, viewing the Xbasic from the Operation Builder can save a lot of time by generating the bare-bones code for you.
- Overview of Stylesheets
/pages/Server/Guide/Design/View/CSS/Overview of Stylesheets.xml
Stylesheets provide enhanced customization options when designing layouts. A Style represents a named collection of object properties used in a layout. Any object (i.e. a button, field, embedded Browse) in a layout can have a style associated with it. For example, if you customized a button to make it green with a drop shadow, you could create a style based on that button which, when applied to other objects, would set the same properties for the other object. Results of applying one button's style to another
are shown below:
- Overview of Batch Operations
/pages/Guides/Desktop/Design/Data/Operation/Overview of Batch Operations.xml
While working with Alpha Anywhere, you can change data at any time by simply navigating to a record and typing in new values. This method is fine if you are just working with a few records, but editing can become enormously time-consuming if you are working with hundreds or thousands of records. To handle larger data manipulation tasks, you can use an Alpha Anywhere Operation. "Operation" is a general term for a process which changes data in existing tables, or even creates new tables as Part of the operation.
- Benefits of Action Scripting
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Introduction/Benefits of Action Scripting.xml
Action Scripting offers several benefits when compared to the traditional methods of creating scripts.