In most cases, when there is a table with data on screen, you can see the button (missions and query forms). Using it, you can export data from the table on screen to a previously defined data source (except Microsoft Access). You will see the following dialog box:

You can:

• specify whether to export the intact table or particular columns only;

• mark the columns to be exported;

• specify aggregate functions (Sum, Count, Min, Max, Average) for particular columns;

• mark the columns to group data by;

• mark the columns to sort data by;

• (optional) specify key fields (required when exporting large MEMO and GENERAL fields)

• move columns in the list.

    You will have to select a data source and enter a table name.

    The exported table can be viewed using the instruments from the \Tools menu.

    Attention! If the data contains large MEMO and GENERAL fields, exporting it to particular data sources (QL+IIS+HTTP, ORACLE, Dataodyssey Expres Server+ HTTP+IIS) will be performed in stages, and the key fields will come in handy. If there are no key fields specified, Dataodyssey Express will add a supplementary key field to the result table and waste no time removing it after.

www.dataodyssey.com         Contents