SQL-016: clsXDeferredPrintCollection.UpdateSQL (dead code)

This SQL property defines an UPDATE XDEFERRED_PRINT statement that would update rows matched by DOCUMENT_DESCR rather than by primary key. The BeforeUpdate 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-016
Operation type	Update
Execution method	Inline (⚠️ not wired to live BeforeUpdate method — BeforeUpdate is fully commented out in this class)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsXDeferredPrintCollection
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate (commented out)

Parameters

No live AddParm calls exist — BeforeUpdate is fully commented out. Bind variables present in SQL text only:

Parameter	Direction	Type	Max length	Description
:CopiesCount	Input	Decimal*	—	Copies count
:CreateDate	Input	Date*	—	Creation date
:CreateUser	Input	String*	30	Creating user
:DocumentDescr	Input	String*	60	Document description (used in both SET and WHERE clauses)
:DuplexCode	Input	String*	5	Duplex code
:FileName	Input	String*	120	File name
:PrintedDate	Input	Date*	—	Printed date
:Sort0Value–:Sort9Value	Input	String* ×10	120 each	Sort/grouping columns
:XMLValueText	Input	NCLOB*	—	XML payload
:XdeferredSeqNum	Input	Decimal*	—	Sequence number

Tables

Table	Access	Columns used
XDEFERRED_PRINT	UPDATE	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

Update XDEFERRED_PRINT Set
    COPIES_COUNT    = :CopiesCount,
    CREATE_DATE     = :CreateDate,
    CREATE_USER     = :CreateUser,
    DOCUMENT_DESCR  = :DocumentDescr,
    DUPLEX_CODE     = :DuplexCode,
    FILE_NAME       = :FileName,
    PRINTED_DATE    = :PrintedDate,
    SORT0_VALUE     = :Sort0Value,
    SORT1_VALUE     = :Sort1Value,
    SORT2_VALUE     = :Sort2Value,
    SORT3_VALUE     = :Sort3Value,
    SORT4_VALUE     = :Sort4Value,
    SORT5_VALUE     = :Sort5Value,
    SORT6_VALUE     = :Sort6Value,
    SORT7_VALUE     = :Sort7Value,
    SORT8_VALUE     = :Sort8Value,
    SORT9_VALUE     = :Sort9Value,
    XML_VALUE_TEXT  = :XMLValueText,
    XDEFERRED_SEQ_NUM = :XdeferredSeqNum
Where
    XDEFERRED_PRINT.DOCUMENT_DESCR = :DocumentDescr
-- ⚠️ Not invoked — BeforeUpdate 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