SQL-003: clsXPrintControlCollection.CreateSQL (dead code)¶
This SQL property returns a scalar SELECT ... FROM DUAL statement, a CodeGen2 template artifact. It is defined in clsXPrintControlCollection.Criteria.CreateSQL but is never executed: the BeforeCreate method in this class is fully commented out.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-003 |
| Operation type | Sequence |
| Execution method | Inline (⚠️ not wired to live BeforeCreate method — BeforeCreate is fully commented out in this class) |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsXPrintControlCollection |
| Criteria property | CreateSQL |
| Lifecycle method | BeforeCreate (commented out) |
Parameters¶
No bind variables are present in the SQL text. No live AddParm calls exist because BeforeCreate is commented out.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| DUAL | SELECT (scalar) | N/A (scalar literal select) |
Sample SQL¶
⚠️
DIRECTORY_NAME_NEXTVALis a CodeGen2 template placeholder token, not a real Oracle sequence. This statement is never invoked.Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Services\SAIF.Services.Printing.Remote\clsXPrintControlCollection.vb