SQL-003: Generate TOWID from tower.TOWER_SEQ¶
This statement retrieves the next value from the tower.TOWER_SEQ Oracle sequence via the DUAL pseudo-table. It generates the TOWID primary key used when inserting a new IMGSYS imaging system record.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-003 |
| Operation type | Sequence |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | SYS (DUAL) |
| Command type | Text** |
| Business object | clsImgsys |
| Criteria property | CreateSQL |
| Lifecycle method | BeforeCreate |
Parameters¶
No parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| DUAL | SELECT (NEXTVAL) | tower.TOWER_SEQ.NEXTVAL |
Sample SQL¶
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Imaging\clsImgsys.vb