1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Get RowID on Progress Insert

Discussão em 'StackOverflow' iniciado por fdantas, Fevereiro 4, 2016.

  1. fdantas

    fdantas Administrator Moderador

    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...

Compartilhe esta Página