SQL-005: clsXDeferredPrintCollection.InsertSQL (dead code)

This SQL property defines an INSERT INTO XDEFERRED_PRINT statement similar to SQL-004 but at the collection level. The BeforeInsert method in clsXDeferredPrintCollection is fully commented out, so this SQL is never executed. No live AddParm calls exist for this property.

Classification

Field	Value
SQL ID	SQL-005
Operation type	Create (Insert)
Execution method	Inline (⚠️ not wired to live BeforeInsert method — BeforeInsert is fully commented out in this class)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsXDeferredPrintCollection
Criteria property	InsertSQL
Lifecycle method	BeforeInsert (commented out)

Parameters

No live AddParm calls exist — BeforeInsert is fully commented out. Bind variables present in SQL text only (types inferred from column names and sibling SQL-004):

Parameter	Direction	Type	Max length	Description
:CopiesCount	Input	Decimal*	—	Number of copies to print
:CreateDate	Input	Date*	—	Date the item was created
:CreateUser	Input	String*	30	Creating user or process
:DocumentDescr	Input	String*	60	Document description
:DuplexCode	Input	String*	5	Duplex printing code
:FileName	Input	String*	120	Source file name
:PrintedDate	Input	Date*	—	Printed date (nullable)
:Sort0Value–:Sort9Value	Input	String* ×10	120 each	Sort/grouping columns
:XMLValueText	Input	NCLOB*	—	XML payload blob
:XdeferredSeqNum	Input	Decimal*	—	Primary key

Tables

Table	Access	Columns used
XDEFERRED_PRINT	INSERT	COPIES_COUNT, CREATE_DATE, CREATE_USER, DOCUMENT_DESCR, DUPLEX_CODE, FILE_NAME, PRINTED_DATE, SORT0_VALUE–SORT9_VALUE, XML_VALUE_TEXT, XDEFERRED_SEQ_NUM

Sample SQL

INSERT INTO XDEFERRED_PRINT (
    COPIES_COUNT,
    CREATE_DATE,
    CREATE_USER,
    DOCUMENT_DESCR,
    DUPLEX_CODE,
    FILE_NAME,
    PRINTED_DATE,
    SORT0_VALUE,
    SORT1_VALUE,
    SORT2_VALUE,
    SORT3_VALUE,
    SORT4_VALUE,
    SORT5_VALUE,
    SORT6_VALUE,
    SORT7_VALUE,
    SORT8_VALUE,
    SORT9_VALUE,
    XML_VALUE_TEXT,
    XDEFERRED_SEQ_NUM
) VALUES (
    :CopiesCount,
    :CreateDate,
    :CreateUser,
    :DocumentDescr,
    :DuplexCode,
    :FileName,
    :PrintedDate,
    :Sort0Value,
    :Sort1Value,
    :Sort2Value,
    :Sort3Value,
    :Sort4Value,
    :Sort5Value,
    :Sort6Value,
    :Sort7Value,
    :Sort8Value,
    :Sort9Value,
    :XMLValueText,
    :XdeferredSeqNum
)
-- ⚠️ Not invoked — BeforeInsert in this class is fully commented out.

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Services\SAIF.Services.Printing.Remote\clsXDeferredPrintCollection.vb