8 Replies Latest reply: Dec 3, 2012 2:05 AM by 910113 RSS

    SELECT next value in table

    754749
      I need to select the next id in a table where the id is a certain value:

      SELECT NEXT(FORM_ID) FROM LOCAL_FORM_DATA WHERE FORM_ID = 2

      This obviously doesn't work, but is there a way to do it?

      This would output whatever the next ID would be. The ID's may not exist so I can't just add 1 to it.