PgDAC

TDADumpOptions.CompleteInsert Property

Used to explicitly specify the table fields names when generating the INSERT SQL query. The default value is False.

Class

TDADumpOptions

Syntax

property CompleteInsert: boolean default False;

Remarks

If the CompleteInsert property is set to True, SQL query will include the field names, for example:

INSERT INTO dept(deptno, dname, loc) VALUES ('10', 'ACCOUNTING', 'NEW YORK');

If False, it won't include the field names, for example:

INSERT INTO dept VALUES ('10', 'ACCOUNTING', 'NEW YORK');
© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback