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