SQL-008: clsXPrintControlCollection.InsertSQL (dead code)¶

This SQL property defines an INSERT INTO XPRINT_CONTROL statement at the collection level. The BeforeInsert 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-008
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	`clsXPrintControlCollection`
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-007):

Parameter	Direction	Type	Max length	Description
`:DirectoryName`	Input	String*	120	Output directory for the print batch
`:DuplexCode`	Input	String*	5	Duplex printing code
`:IdmPathName`	Input	String*	30	IDM destination path
`:Md5HashValue`	Input	String*	40	MD5 hash
`:ProcessedDate`	Input	Date*	—	Processed date
`:XmlFileName`	Input	String*	120	XML file name
`:XprintControlSeqNum`	Input	Decimal*	—	Primary key

Tables¶

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

Sample SQL¶

INSERT INTO XPRINT_CONTROL (
    DIRECTORY_NAME,
    DUPLEX_CODE,
    IDM_PATH_NAME,
    MD5_HASH_VALUE,
    PROCESSED_DATE,
    XML_FILE_NAME,
    XPRINT_CONTROL_SEQ_NUM
) VALUES (
    :DirectoryName,
    :DuplexCode,
    :IdmPathName,
    :Md5HashValue,
    :ProcessedDate,
    :XmlFileName,
    :XprintControlSeqNum
)
-- ⚠️ 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\clsXPrintControlCollection.vb