Using Xbasic to Create Queries
/documentation/pages/Guides/Desktop/Design/Platform/Xbasic/Using Xbasic to Create Queries.xml
The RADIO2 option button asks the user whether to preview or print, and stores the result into a form variable named print_option. BUTTON1 executes an Xbasic routine that examines all these variables and calls the appropriate preview or print functions.
How to Export a SQL Query to Excel Using Xbasic
/documentation/pages/HowTo/Databases/Export SQL Query to Excel.xml
Excel files can be generated with data from Xbasic SQL queries in Alpha Anywhere.
Using Xbasic to Control Access to a Form
/documentation/pages/Guides/Desktop/Design/Platform/Xbasic/Using Xbasic to Control Access to a Form.xml
The Invoice form contains the btnEditItems0 ( Zoom ... ) button. The Xbasic code run by the button's OnPush event creates and sets the value of the global variable varInvoice_Number, then displays the Items form (from the AlphaSports sample database). The result is that the global variable varInvoice_Number only exists when the Items form is called by the Invoice form.
Using Xbasic to Select a Record and Display a Form
/documentation/pages/Guides/Xbasic/Xbasic in Desktop Applications/Using Xbasic to Select a Record and Display a Form.xml
Button1 runs Xbasic code that loads the Invoice form to display the details of the invoice selected in the embedded browse.
Using Xbasic to Read and Write to a Table
/documentation/pages/Server/Guide/Design/Data/FieldRules/Using Xbasic to Read and Write to a Table.xml
The new Alpha Anywhere developer eventually comes to the point where he or she would like to write a script that directly reads from and writes to a table. This topic provides a couple of simple examples that you can elaborate upon. The are based on the Customer table in the AlphaSports sample database.
Learning Xbasic - Using Xbasic with SQL Tables
/documentation/pages/Guides/Desktop/Design/Platform/Xbasic/Learning Xbasic - Using Xbasic with SQL Tables.xml
A tutorial about learning Xbasic. Includes a number of videos and procedural guides for working with Xbasic and sql tables.
Using Xbasic to Read and Write to a Table
/documentation/pages/Guides/Mobile and Web Components/Grid/Code/Client-side Events/Using Xbasic to Read and Write to a Table.xml
The new Alpha Anywhere developer eventually comes to the point where he or she would like to write a script that directly reads from and writes to a table. This topic provides a couple of simple examples that you can elaborate upon. The are based on the Customer table in the AlphaSports sample database.
Using the Xbasic Explorer to View Object Properties
/documentation/pages/Guides/Xbasic/Xbasic in Desktop Applications/Using the Xbasic Explorer to View Object Properties.xml
To determine the list of properties associated with an object, use the Xbasic Explorer. To display the Xbasic Explorer, select View > Code editor from the Control Panel menu. For example, if you have a form called Customer, navigate in the Xbasic Explorer to Objects > Windows > Customer > Properties to see a list of the properties associated with the form (as shown below):
Using Addin Variables to Create a Multi-Database Application
/documentation/pages/Guides/Desktop/Design/View/Workspace/Using Addin Variables to Create a Multi-Database Application.xml
Our agency is responsible for administering many programs for the needy population in our county. For over 10 years, we have used Alpha Software to handle the task. The system is currently written in Alpha5 version 1 and it has performed admirably! Our user interface is one where they sign into the system with a user-id and password. Once authenticated, the user is presented with a "Main Menu" application. Applications were a series of "card stacks", which are forms not associated with any table or set, only the application. From this Main Menu, a user can get to (provided they have appropriate security) whichever application they need. Application-to-application communication was fairly straightforward using an "app_run" command. We were also able to create "Global" variables that would be available to all called applications. With the release of version 2 of Alpha 5, card stacks were no longer being used, and Xbasic, as we knew it, had changed. The methodology we used in our system design could no longer be used!
How to set Multiple Properties at Once Using Xbasic
/documentation/pages/HowTo/Internationalization/Setting Multiple Properties with Xbasic.xml
Xbasic can be used to set one or more properties for multiple controls in a Grid or UX component. This is useful in certain situations, such as adding language tags to a large number of controls.