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
| Data Outsource windowA 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 buttonAlways 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 usefulAfter 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 buttonThe 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. |