Top Previous Next

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


property ForcedColumns : TStrings;


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