How to pass SQL Arguments into SQL statements.

How to create and use Arguments, and structure scripts, relating to Select statements.

A common design practice is to filter a grid based on the value of an argument. A common design pattern is to print out the value of that argument in a freeform region that you place above or below the grid.

This example uses an argument to select records from the AlphaSports.mdb customer table. We will filter the selected records using an argument for the bill_state_region field. In the Interactive window create the AlphaDAO objects that you will need.

Arguments can be defined for a Page Layout Component which can be used in server-side show/hide expressions as well as filtering Grid Components and Reports.

Learn how to use the MongoDB and CouchDB APIs in Xbasic.

Defining connection strings, and instructions for connecting to specific databases.

Arguments Properties

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

In general, it's good to test Xbasic code of any sort first in an Interactive window. When you find good sequences for testing, you can copy them into Xbasic scripts, along with notes about the expected output. Your Xbasic scripts can easily include code to set up and tear down test databases.