I'm working with classic ASP VB.
I have a webpage with records showing in grid (Repeat Region). (MSSQL)
Its ORDER BY "volgorde" DESC.
My target is to let costumers kan easily change the order by position -1 or +1 and stored this in my database table.
HOW IT'S WORK NOW?
On each row I added a form that updates the record by a nummeric field "volgorde" value +1 or update -1.
If I insert a new record I set the default "volgorde" value to '1'
So in this case its works fine but not perfect because there can be equal values in "volgorde".
Is there a solution in SQL that all the numeric value from field "volgorde" change also automatic by update 1 record. (+1 -1)
I'm looking a freelancer that works on big screen and works over Teamviewer or AnyDesk and Skype.
I don't allow SFTP or Database connections.
I have MSSM installed on my PC where I make my query's.
Do you have experience in SQL and classic ASP? Get in chat.
Thanks in advance.