vendredi 8 février 2019

Count number and start with 1 again

im thinking a long time for a solution but i dont find any to fix my problem:

Explanation: I have the variable x. x is a ID number between 1 and 99 in my oracle db.

After i fill out the form i insert till max 8 rows in my db (because i have dynamic textboxes and so i insert from 1 row till 8 tows). Now i want to count x till 99 and after it reached 99 it should start at 1 again.

The problem is that i actually insert the following line:

Row1: Insert (text, 97) (97 is the ID) Row2: Insert (text, 98) (98 is the ID) Row3: Insert (text, 99) (99 is the ID) Row4: Insert (text, 100) (100 is the ID) now here is the problem, it should begin at 1 again and insert 1. Row5: Insert (text, 101) (101 is the ID) should be 2. ...

I hope that someone knows easily the solution.

Thank you very much

Aucun commentaire:

Enregistrer un commentaire