[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: 4GL sequence access from SQL

  • Thread starter Thread starter Ken McIntosh
  • Start date Start date
Status
Not open for further replies.
K

Ken McIntosh

Guest
I see you're running this from the ABL, not SQL-92. When using the ABL to execute SQL it uses SQL-89 (and btw this is deprecated functionality). I believe the NEXTVAL stuff only applies in SQL 92. You can use the NEXT-VALUE() function to get the next value from the sequence, as follows: NEXT-VALUE(NextCustNum)

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