INSERT INTO SQL Statement

INSERT statements add new records to the end of the data file. Any field not specified is left blank, with the exception of fields in the NCS Header. NCS Header fields may not be specified in an insert statement, and will be initialized as follows:

Application Number, Serial Number, Document Number and Record Marked Deleted Flag are all set to the proper values and can not be specified by the solution program.

The supported syntax is:

INSERT INTO <table> (<attrib-list>) VALUES(<value-list>)

Each document in an application defines both a table and a view. The table name is the name of the document, and the view name is "Simple View of " followed by the document name. In addition, each application contains a table called MASTER and a corresponding "Simple view of MASTER". A view name can be used anywhere a table name is. Column names are the fields defined for a document.

Only a single table can be specified.

You can use the document number instead of the document name. This is not as much an optimization as a convenience considering the document titles are typically verbose. Keep these rules in mind:

• Document number must be specified in decimal format like 1, 2, 5 and so on.
• Document number 0 maps to the Master document.
• Do not use leading zeros for the document number.
• Specifying an invalid document number will cause a SQL parse error.
• It is not usually a good practice to hardwire document numbers.

The attrib-list is a list of field names for the document. One or more fields may be entered, separated by a comma.

The value-list is the data for the field, a number or string literal may be entered.

See also

SQL Statements Accepted by the Data Provider

SQL Best Practices

FOR XML Syntax Errors Reference