[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Understanding Sequence report

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> Sequence Name: Are these represent tables or Columns of table? Sequences are the separate db objects with their own names. They can have no relations to any table or table's field > Max/Min Value: Max value the records can be stored. in my report i see '?' values, what is '?' means in report. '?' means the max possible value: 2,147,483,64 if the sequences are 32-bit 9223372036854775807 if the sequences are 64-bit > Cycle?: the same sequence number will be reused When Cycle = NO and a sequence reached Max/Min Value then NEXT-VALUE(sequence) will return the unknown value. Otherwise the values will start with Initial Value. P.S. Documentation by the link above is incorrect regarding 'Cycle at limit".

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