Documentation
Home Evaluation Summary for programmers Product limitations Goals of Axisbase Quick start Installation Using the launchpad and opening databases Connecting to a sample database Using building blocks Planning Define the purpose Define the requirements Borrow existing work Determine the architecture Design the data model Design the process model Deploy and maintain the product
Tutorials
building blocks
Performing a mailmerge Bulk e-mailing
Programming
Single-threaded progress indicator in c#
Reference
Database menu items
Import XML Save Copy As Integrity Check Change Password
Database Properties window
Opening the database properties window Record types tab Display types tab Roles and Users tabs Sidebar tab Database ID/Links tab Counters tab
Building blocks
Building blocks window Editing grids and cells Hyperlinks and nesting Data Subset window Data Outsource window List window Window window Report window Bulk Operation window Label Printer window Choosing a data source
Special topics
Expression syntax Browse records Storing building blocks within other building blocks Programming Using custom code in building blocks Using Axisbase as an embedded database Axis1.Util namespace reference Axis1.Data namespace reference (Fishnets) Axis1.Data namespace reference (other) Axis1.Forms namespace reference

List window

A list is the only building block that allows editing records. A list can be included inside a window, report, or label printer, or inside another list.

Some prerequisite information that will help you understand lists is found here: Storing building blocks within other building blocks; Hyperlinks and nesting; and Editing grids and cells.

Options on the General tab

  • Data Source - Use this to select the source of the data for the list. Refer to Choosing a data source

  • Initial filters - Normally this is blank. If you enter a full column name here (for example MOON.customer.status), the Results grid will automatically sort by that column and open the filter bar.

  • Sticky margin - This is useful when your repeater band is particularly tall. For grid-type lists, leave this at zero. If the sticky margin is 1, then the first row of cells in the repeater band (not counting the two blank rows) will stick to the top of the screen while scrolling in the same way the header band sticks. Use 2 or more if you want more rows of cells to stick.

  • Background color - Controls the default background color of the list. All cells that have no color defined will inherit the default color.

  • User can edit/add/delete rows - Check these boxes to allow users to edit, add, and delete rows in the list. If you are using a database server and some users don't have rights to add, edit, or delete, those users still won't be able to make changes even if these boxes are checked.

  • Labels above (grid layout) - Check this if your basic layout strategy is grid-like, and leave it blank if the layout strategy is card-like (labels on the left). This checkbox controls two things: (1) the auto-generation of layouts based on loaded data, and (2) the order in which cells are visited with the user presses the Tab key.

Layout tab

To manipulate cells in the layout, refer to Editing grids and cells.

The list is rendered in this order:

  • Introduction - once at the top of the list

  • Header - once on the top of each page or screen

  • Repeater - once for each record in the in-memory data table

  • Conclusion - once at the end of the list

Nesting lists

To show data in master/detail arrangement (either for reports or data entry), you first need to create a data subset that produces an in-memory data set having a master/detail structure. Once you have that, when you create a new list based on it, Axisbase automatically creates a basic layout to work from. The auto-created layout includes the detail list as a nested building block.

In the Layout tab of the master list, right click on the cell containing the detail list, and choose Open Nest/Link Item. You can leave both master and detail windows open while you make changes to the layouts. If you go to the Results tab of the detail list window, you will see only details, but the same details will be shown grouped by master record in the Results tab of the master list window.

You can nest additional levels if needed, but this is unusual.

(c) 2014-2015 Divergent Labs, Inc.