4D v13.4
SQL EXPORT SELECTION
- 4D Language Reference
-
- SQL
-
- Overview of SQL Commands
- On SQL Authentication Database Method
- Begin SQL
- End SQL
- Get current data source
- GET DATA SOURCE LIST
- Is field value Null
- QUERY BY SQL
- SET FIELD VALUE NULL
- SQL CANCEL LOAD
- SQL End selection
- SQL EXECUTE
- SQL EXECUTE SCRIPT
- SQL EXPORT DATABASE
- SQL EXPORT SELECTION
- SQL GET LAST ERROR
- SQL GET OPTION
- SQL LOAD RECORD
- SQL LOGIN
- SQL LOGOUT
- SQL SET OPTION
- SQL SET PARAMETER
- START SQL SERVER
- STOP SQL SERVER
- USE EXTERNAL DATABASE
- USE INTERNAL DATABASE
SQL EXPORT SELECTION
| SQL EXPORT SELECTION ( aTable ; folderPath {; numFiles {; fileLimitSize {; fieldLimitSize}}} ) | ||||||||
| Parameter | Type | Description | ||||||
| aTable | Table |
|
Table from which to export selection | |||||
| folderPath | Text |
|
Pathname of export folder or "" to display folder selection dialog box | |||||
| numFiles | Longint |
|
Maximum number of files per folder | |||||
| fileLimitSize | Longint |
|
Maximum size of Export.sql file (in KB) | |||||
| fieldLimitSize | Longint |
|
Size limit (in bytes) below which the contents of a Text, BLOB or Picture field are embedded into the main file | |||||
The SQL EXPORT SELECTION command exports in SQL format the records of the current selection of the 4D table designated by the aTable parameter.
This command is nearly identical to the SQL EXPORT DATABASE command. The main difference between these two commands is that SQL EXPORT SELECTION only exports the current selection of aTable whereas SQL EXPORT DATABASE exports the entire database. Also, unlike the SQL EXPORT DATABASE command, this command does not work with external SQL databases. It can only be used with the main database.
Refer to the description of the SQL EXPORT DATABASE command for a detailed description of the functioning and parameters of these commands.
If the current selection is empty, the command does nothing. Note that in this case, the destination folder is not emptied.
If the export is carried out correctly, the OK variable is set to 1. Otherwise, it is set to 0.
Product: 4D
Theme: SQL
Number:
1064
Created: 4D v12
Modified: 4D v12.1
Dump***
