Getting the value from nextval()
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?
Manage your list subscriptions at lists.omnis-dev.com