F
fatboycanteen
When I filled the db data to the dataset
eg. (id_col is autoincrement)
id_col field1
97 100
98 200
99 15
100 72
---
when I add two rows to it (newrow-> table.add)
id_col field1
97 100
98 200
99 15
100 72
101 79 <- new row
102 80 <- new row
then I delete the first row (row.deleted)
id_col field1
97 100 <- marked deleted (rowstate)
98 200
99 15
100 72
101 79
102 80
then I add one row
id_col field1
97 100 <- marked deleted (rowstate)
98 200
99 15
100 72
101 79
102 80
104 77 <- new row
The problem is that the id_col is 104, why not 103
Anyone can solve the problem. Thank You
eg. (id_col is autoincrement)
id_col field1
97 100
98 200
99 15
100 72
---
when I add two rows to it (newrow-> table.add)
id_col field1
97 100
98 200
99 15
100 72
101 79 <- new row
102 80 <- new row
then I delete the first row (row.deleted)
id_col field1
97 100 <- marked deleted (rowstate)
98 200
99 15
100 72
101 79
102 80
then I add one row
id_col field1
97 100 <- marked deleted (rowstate)
98 200
99 15
100 72
101 79
102 80
104 77 <- new row
The problem is that the id_col is 104, why not 103
Anyone can solve the problem. Thank You