EPUB | CHM | PDF

TPSQLCopy.Properties.ForcedColumns

Top Previous Next

List of columns to be processed specifically depends on COPY process direction in CSV mode.

Syntax:

property ForcedColumns : TStrings;

Description:

Fill ForcedColumns to include specific processing of some columns in CSV mode. If TPSQLCopy receives data from server then it forces quoting to be used for all non-NULL values in each specified column. NULL output is never quoted.

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.

Property has no effect if coCSV is not included into Options property is specified.

See also: SQL, Options