Hmm. Edit about the below: perhaps I've posted here thinking it was the thread associated with a different version of SBA (I'm on list for several). Sorry for toe stepping. Running out of time to edit. But still able to possibly answer questions related to the solution.
A lot going on here, 1) using a very old as far as I know no longer maintained version of SBA, 2) looks like you could use at least three options to move forwards, either alter the database, so that every new item has a default value that is a constant (all new items would have the same sort value), you could modify the database field to autonumber such that each would be assigned a new/unique likely unchangeable sort value. You could modify the query to add a value to the table for that field and that value could be a constant (to be changed later) or it could be determined by the last sort number and incremented in a way applicable to the desired outcome. The drastic action would be to delete the field from the table and any other place that the sort field is used/accessed, but that doesn't seem like a worthwhile venture.
So, it would depend on how you wish to move forward with the issue of that software which doesn't occur with the version that has primarily been discussed, tested, and used on the more recent versions of ZC.
Bookmarks