SQL-018: clsXPrintControlCollection.UpdateSQL (dead code)

This SQL property defines an UPDATE XPRINT_CONTROL statement at the collection level. The BeforeUpdate method in clsXPrintControlCollection is fully commented out, so this SQL is never executed. No live AddParm calls exist for this property.

Classification

Field	Value
SQL ID	SQL-018
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	clsXPrintControlCollection
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 (:XprintControlSeqNum appears twice — once in SET, once in WHERE):

Parameter	Direction	Type	Max length	Description
:DirectoryName	Input	String*	120	Output directory
:DuplexCode	Input	String*	5	Duplex code
:IdmPathName	Input	String*	30	IDM path name
:Md5HashValue	Input	String*	40	MD5 hash
:ProcessedDate	Input	Date*	—	Processed date
:XmlFileName	Input	String*	120	XML file name
:XprintControlSeqNum	Input	Decimal*	—	Primary key (SET clause and WHERE clause — appears twice)

Tables

Table	Access	Columns used
XPRINT_CONTROL	UPDATE	DIRECTORY_NAME, DUPLEX_CODE, IDM_PATH_NAME, MD5_HASH_VALUE, PROCESSED_DATE, XML_FILE_NAME, XPRINT_CONTROL_SEQ_NUM

Sample SQL

Update XPRINT_CONTROL Set
    DIRECTORY_NAME          = :DirectoryName,
    DUPLEX_CODE             = :DuplexCode,
    IDM_PATH_NAME           = :IdmPathName,
    MD5_HASH_VALUE          = :Md5HashValue,
    PROCESSED_DATE          = :ProcessedDate,
    XML_FILE_NAME           = :XmlFileName,
    XPRINT_CONTROL_SEQ_NUM  = :XprintControlSeqNum
Where
    XPRINT_CONTROL.XPRINT_CONTROL_SEQ_NUM = :XprintControlSeqNum
-- ⚠️ 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\clsXPrintControlCollection.vb