Store
This script function creates a
Syntax:
Store [ fieldlist from] table into filename [ format-spec ];
The statement will create an explicitly named
The statement can only export fields from one data
table. If fields from several tables are to be exported, an explicit
The text values are exported to the
Arguments:
Argument | Description |
---|---|
fieldlist::= ( * | field ) { , field } ) |
A list of the fields to be selected. Using * as field list indicates all fields. field::= fieldname [as aliasname ] fieldname is a text that is identical to a field name in table. (Note that the field name must be enclosed b straight double quotation marks or square brackets if it contains spaces or other non-standard characters.) aliasname is an alternate name
for the field to be used in the resulting |
table | A script label representing an already loaded table to be used as source for data. |
filename |
The name of the target file including a valid path to an existing folder data connection. Example: 'lib://Table Files/target.qvd' In legacy scripting mode, the following path formats are also supported:
|
|
The format specification consists of the text txt
for text files, or the text qvd for |
Examples:
Store mytable into xyz.qvd (qvd);
Store * from mytable into 'lib://FolderConnection/myfile.qvd';
Store Name, RegNo from mytable into xyz.qvd;
Store Name as a, RegNo as b from mytable into 'lib://FolderConnection/myfile.qvd';
Store mytable into myfile.txt (txt);
Store * from mytable into 'lib://FolderConnection/myfile.qvd';