[stackoverflow] [progress Openedge Abl] Get Rowid On Progress Insert

Status
Not open for further replies.
S

Shiniece

Guest
I have a table which doesn't have primary key. I needed to add a primary key to the table so I added a column called 'ID'. I am attempting to use the rowid to insert unique ids into this new column. How would I go about getting the rowid when inserting a new record. This is in a Progress database.

INSERT INTO PUB.DETAILS (LASTUPDATED, FORMERVALUE, NEWVALUE, ID)
VALUES ('09/16/2015', 'NEW ITEM', 'ESISTING ITEM', '?')

Continue reading...
 
Status
Not open for further replies.
Top