Getting the value from nextval()

Das Goravani das at Goravani.com
Sun Jan 28 00:17:55 EST 2018


One can issue a SELECT nextval(seq_field)

But how does one read the result in Omnis?

I am aware you can use nextval(seq_field) as a value in an INSERT INTO statement but I’m wondering if we can get the value at the beginning of data entry instead of after it’s inserted

If it can only be done with insertion, how do we for sure fetch that just inserted row back so we can see the number assigned?


More information about the omnisdev-en mailing list