SAIF.Services.Printing.Remote SQL catalog¶

This page indexes all SQL statements in this library (22 live IBusinessCriteria properties + 1 supplemental property), grouped by CRUD type. Statements flagged ⚠️ contain live SQL text but are not wired to an executing Before* lifecycle method — they are dead/orphaned code.

Sequence operations¶

SQL ID	Description	Sequence	Tables	Business object
SQL-001	`clsXDeferredPrint.CreateSQL` — scalar sequence select ⚠️ dead/unwired	`COPIES_COUNT_NEXTVAL` (CodeGen2 artifact)*	`DUAL`	`clsXDeferredPrint`
SQL-002	`clsXDeferredPrintCollection.CreateSQL` — scalar sequence select ⚠️ dead/unwired	`COPIES_COUNT_NEXTVAL` (CodeGen2 artifact)*	`DUAL`	`clsXDeferredPrintCollection`
SQL-003	`clsXPrintControlCollection.CreateSQL` — scalar sequence select ⚠️ dead/unwired	`DIRECTORY_NAME_NEXTVAL` (CodeGen2 artifact)*	`DUAL`	`clsXPrintControlCollection`

Create operations¶

SQL ID	Description	Type	Tables	Business object
SQL-004	`clsXDeferredPrint.InsertSQL` — insert a deferred print item	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrint`
SQL-005	`clsXDeferredPrintCollection.InsertSQL` ⚠️ dead/unwired	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrintCollection`
SQL-006	`clsXDocument.InsertSQL` — insert a print job document	Inline	`XDOCUMENT`	`clsXDocument`
SQL-007	`clsXPrintControl.InsertSQL` — insert a print-control batch header	Inline	`XPRINT_CONTROL`	`clsXPrintControl`
SQL-008	`clsXPrintControlCollection.InsertSQL` ⚠️ dead/unwired	Inline	`XPRINT_CONTROL`	`clsXPrintControlCollection`

Read operations¶

SQL ID	Description	Type	Tables	Business object
SQL-009	`clsXDeferredPrint.RetrieveSQL` ⚠️ dead/unwired (hard `Throw`)	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrint`
SQL-010	`clsXDeferredPrintCollection.RetrieveSQL` — dynamic WHERE/ORDER BY	Inline (dynamically assembled)	`XDEFERRED_PRINT`	`clsXDeferredPrintCollection`
SQL-011	`clsXDocumentCollection.RetrieveSQL` — per-document retrieve with routing join (`ByDocSeq`)	Inline	`XDOCUMENT`, `XPRINTER_BIN`, `XPRINTER`	`clsXDocumentCollection`
SQL-012	`clsXDocumentCollection.RetrievePrintSQL` — grouped retrieve (`ByPrintGroup`); supplemental non-interface property	Inline	`XDOCUMENT`, `XPRINTER_BIN`, `XPRINTER`	`clsXDocumentCollection`
SQL-013	`clsXPrintControl.RetrieveSQL` — single batch header by PK	Inline	`XPRINT_CONTROL`	`clsXPrintControl`
SQL-014	`clsXPrintControlCollection.RetrieveSQL` — pending/stale batches	Inline	`XPRINT_CONTROL`	`clsXPrintControlCollection`

Update operations¶

SQL ID	Description	Type	Tables	Business object
SQL-015	`clsXDeferredPrint.UpdateSQL` — update a deferred print item by PK	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrint`
SQL-016	`clsXDeferredPrintCollection.UpdateSQL` ⚠️ dead/unwired	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrintCollection`
SQL-017	`clsXPrintControl.UpdateSQL` — update a print-control batch header by PK	Inline	`XPRINT_CONTROL`	`clsXPrintControl`
SQL-018	`clsXPrintControlCollection.UpdateSQL` ⚠️ dead/unwired	Inline	`XPRINT_CONTROL`	`clsXPrintControlCollection`

Delete operations¶

SQL ID	Description	Type	Tables	Business object
SQL-019	`clsXDeferredPrint.DeleteSQL` — delete a deferred print item by PK	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrint`
SQL-020	`clsXDeferredPrintCollection.DeleteSQL` ⚠️ dead/unwired	Inline	`XDEFERRED_PRINT`	`clsXDeferredPrintCollection`
SQL-021	`clsXDocumentCollection.DeleteSQL` — delete documents by batch PK ⚠️ no `BeforeDelete` override	Inline	`XDOCUMENT`	`clsXDocumentCollection`
SQL-022	`clsXPrintControl.DeleteSQL` — delete a print-control batch by PK	Inline	`XPRINT_CONTROL`	`clsXPrintControl`
SQL-023	`clsXPrintControlCollection.DeleteSQL` — delete a print-control batch by PK	Inline	`XPRINT_CONTROL`	`clsXPrintControlCollection`

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

Sources¶

Services\SAIF.Services.Printing.Remote\clsXDeferredPrint.vb
Services\SAIF.Services.Printing.Remote\clsXDeferredPrintCollection.vb
Services\SAIF.Services.Printing.Remote\clsXDocument.vb
Services\SAIF.Services.Printing.Remote\clsXDocumentCollection.vb
Services\SAIF.Services.Printing.Remote\clsXPrintControl.vb
Services\SAIF.Services.Printing.Remote\clsXPrintControlCollection.vb