Skip to content

SQL-002: Generate Note

Returns the next identifier value used when creating note.

Classification

Field Value
SQL ID SQL-002
Operation type Sequence
Execution method Inline
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsNote
Criteria property CreateSQL
Lifecycle method Create

Parameters

No parameters. This statement does not accept bind input.

Tables

No tables are referenced by this SQL statement.

Sample SQL

SELECT CBP_NOTE_SEQ.NEXTVAL FROM DUAL

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Business\SAIF.Business.Provider\clsNote.vb