EPUB | CHM | PDF

TPSQLCopy.Properties.SQL

Top Previous Next

Contains the text of the SQL statement to execute for the COPY operation.

Syntax:

property SQL : TStrings;

Description:

Fill SQL with a SELECT or VALUES command whose results are to be copied from server.

In sending data mode process each specified column as though it were quoted and hence not a NULL value. For the default null string in CSV mode (''), this causes missing values to be input as zero-length strings.

SQL property used only when copying data from server. If both Tablename and SQL specified then TPSQLCopy discards Tablename value and uses SQL instead. If TPSQLCopy sends data to server then SQL is ignored silently.

See also: Tablename