Autofill datatable columns with increasing numbers (1 Viewer)

sure4sure

New member
Local time
Yesterday, 23:12
Joined
Nov 27, 2006
Messages
3
Fill datatable columns with increasing numbers

How to fill datatable columns with increasing numbers - like the way in Excel?

Given a datatable with 2 columns : ID & Data.
Supposed that there are 100 EXISTING records.

EXISTING datatable

ID Data
---------------------
1 700
2 400
3 399
...
98 100
99 600
100 500

Resulting datatable

ID Data
---------------------
1 700
2 400
3 300
4 301
5 302
6 303
7 304
8 305
9 306
10 307
...
100 500

Given a form with 3 textfields: StartID, EndID & StartData.

How to fill the datatable (not form) column "Data", in the range of ID specified by user, with consecutive increasing numbers?

Example:

StartID --> 3
EndID -->10
StartData --> 300

Then, in the datatable, fill record with ID 3 with 300 (StartData). And fill the ongoing records (ID4, ID5, ID6...ID10) with consecutive increasing numbers?

Many many thanks for any help and discussion!
 
Last edited:

Users who are viewing this thread

Top Bottom