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
building blocksPerforming a mailmerge Bulk e-mailing
ProgrammingSingle-threaded progress indicator in c#
Database menu itemsImport XML Save Copy As Integrity Check Change Password
Database Properties windowOpening the database properties window Record types tab Display types tab Roles and Users tabs Sidebar tab Database ID/Links tab Counters tab
Building blocksBuilding 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 topicsExpression 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
Data Outsource window
A Data Outsource allows you to load temporary data sets, much like a Data Subset. The difference is that the source of data is outside the database.
You can use the data set in the same way that you use a data set derived from a Data Subset building block. For example, you could print mailing labels from data in a text file, using Axisbase just to process information, but not store it.
There are two main options of sources: File and Code. Code is covered in separate documentation. The rest of this page covers file sources.
Options on the File tab
Test Import button
Always do a test import after filling out the basic information. This reads the input file and fills out the table name and list of columns, and alerts you of any errors.
After the test import, you can modify the columns. You can change the name or data type. If you set the data type to "skip this column", that column won't be imported.
Connecting a Data Outsource to something useful
After setting up a data outsource, it can be connected to a list or bulk operation in the same way a data subset is connected.
Or you can build a data subset on top of the outsource. In the data subset window, for a table's data source, choose "Start with the results of a Data Outsource". This technique allows you to dynamically merge or relate data from the database with data from a different source.
Nested Tables button
The Nested Tables button is used in a special circumstance when you are importing a master table and detail table together in the same import. In that case, the list of columns on the Data Outsource window only shows the master table columns. Press Nested Tables to see the Table Structure window, which shows a tree diagram of the tables in the import. From there, choose a table and press Columns to view and edit the column definitions for that table.