4.7 Save the Results
You can save the results displayed in the Results window in a variety of file formats. By doing this, you can extract data from your database to update a database on your PC. Most PC applications support the Database Format (DBF) file.
Results must be saved before they can be displayed using a report.
To save the results, from the Results window, select the File command from the menu bar and choose either
- the Save command, to save new results.
- the Save As command to save the results to another file.
The Results Save As dialog box is displayed.
Save as Type
Select the format in which you want to save your data. The formats available include:
|
MS Access Format |
.MDB |
|
Excel Format |
.XLS |
|
Excel 2003 XML Format |
.XML |
|
HTML Format |
.HTM |
|
XML Format |
.XML |
|
ASCII Text Fixed |
.TXT |
|
ASCII Tab Delimited |
.TXT |
|
ASCII Comma Delimited |
.TXT |
|
dBASE Format |
.DBF |
|
dBbase for SCR format |
.DBF |
Note 1: To save the results for input to a LANSA Client report, you can either choose the MS Access, dBASE or dBASE for SCR format. If you are likely to link this Query with another Query in Crystal Reports then you must choose the MS Access (MDB) or dBASE for SCR format (DBF).
If you are saving a file in Excel 2003 XML Format, HTML Format, XML Format, ASCII Text Fixed, ASCII Tab Delimited or ASCII Comma Delimited the file will be saved using UTF-8 encoding if the results contain any Unicode fields.
File Name
Enter a name for the file. This name should be the same as the query used to create it. It should also be the same as the matching Report Format file, if the results are to be printed as a report.
The file name's length can vary depending on the file type:
|
DBF |
Normal MS Windows file names. For example Report Table File.DBF |
|
XLS |
Maximum of 60 characters. This name must not start with a number or include spaces. |
|
TXT |
Uses normal MS Windows file names. |
Save in
You can choose the location for the file by selecting from the folders listed. By default, the file will be saved in the LANSA Client folder.
Saving the File Details
Once you are satisfied with the entries in this dialog box, select the Save button or press the key.
You can cancel the save by selecting the button or pressing the key.
Note:
- Fields marked "Not Displayed" using the Sort Options command will not be saved with the rest of the data.
- Fields will be written to the file in the sequence selected for the query (as displayed in the Selected Fields area of the Query window).
- Grouping conditions and totals, if specified, will not be saved with the data.
Further Information