The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting Notes to Tables

Highlighted
Lizabeth
Regular Collector

Inserting Notes to Tables

Hello,

We are trying to add notes by inserting them directly into Base Tables. I had the following concerns with the same -

1. We are using the Sequence 'KNTA_NOTE_ENTRIES_S' to populate the note_entry_id column, However it shows a different value in the database when I insert the notes through 'Requests' than what it shows when I do a 'SELECT KNTA_NOTE_ENTRIES_S.CURRVAL'. I Hope this is accepatble.

2. I Hope there is just one table that needs to be updated 'knta_note_entries'

3. I Hoep there are no issues seen when inserting directly to base tables.

Thanks for all your help.

//Add this to "OnDomLoad" event