Auto Increment Order Number

[Memo]

Here’s something I put together for an order number sequence that you can reset:

After ending a work period then starting a new one the order numbers are continuing instead of starting from 1

Here’s a script for a sequence with floating zeros: function get() { var q = "SELECT Value From dbo.ProgramSettingValues WHERE Name = 'SequenceNumber'"; var r = sql.Query(q).First; var sequenceNumber = r; if (r == null) { var q = "INSERT INTO dbo.ProgramSettingValues (Value, Name) VALUES ('1', 'SequenceNumber')"; sql.Exec(q); sequenceNumber = 1; } else { sequenceNumber++; } q = "UPDATE dbo.ProgramSettingValues SET Value = '"+sequenceNumber+"' WHERE…