|
<< Click to Display Table of Contents >> Save query result as table |
  
|
|
<< Click to Display Table of Contents >> Save query result as table |
|
When querying a table via SQL and saving the resulting output as a table, the saved table will retain the same field data types as the queried table except AUTOINC data, as Paradox does not accept populating AUTOINC fields.
This may be used to make replicas of existing tables as well as to generate tables with new structure and data and always generating tables of the current table format and table level.
This feature anables you to copy a table to nay destination in contrast to the [Tables]..[Copy Table], which alway copies to the current database and retaining all field types and data as well as table settings.
Derived replica tables will neither inherit any index(es) nor any validity checks of the source table.
This can be utilized as a way clearing a table from its validity checks if desired.
The SQL output to disc table correspond the Borland Database Desktop's specified "Answer table" called as accessible as one of the settings of the DBD SQL Query properties in contrast to the default volatile SQL "Live query view".
If you run an SQL like
SELECT LastName + ', ' + FirstName AS FullName FROM Addresses;
and subsequently choose an Export|Save Current Query Result as ...
the field FullName of the resulting table automatically will be of the summed size of LastName, FirstName and the added ', '.
If querying e.g. a Paradox 7 table, the resulting table will be of the table format currently active as selected by PdxEditor and the Level no higher than set by the BDE configuration (and displayed in the PdxEditor top band).
If the PdxEditor is in dBASE mode and you query a Paradox table, the output table save format will be in the dBASE format - however, this may be dis-recommended unless in the dBASE 7 mode due to the very restricted field names for the dBASE III+, IV and 5 levels.
If in dBASE 5 or 7 mode and querying a paradox table paradox Binary fields unfortunately translates into the Memo field type losing possible embedded BLOB data of the paradox table, which is a BDE limitation (or error) also seen with other BDE dependent applications as e.g. the Borland Database Desktop 7. Also paradox Bytes data will not translate to any corresponding dBASE field.
Display of table columns retrieved with standard SQL (SELECT * FROM TableName) may be reordered by simply dragging the column headers as desired and without affecting column order of the source table.
This reordered column display may be exported as shown into the new destination table of choice and reflecting the reordered column sequence of the original source table.
See also Redefining a Table.
__________________________