hi guys,

the thing is i am creating a program in vb.net that connects to an informix database and then you can add registers through vb.net to de db

everything works well but the problem starts when I want to delete a register from there i have a button that deletes the selected register from a datagrid and the button deletes it correctly

but the index of the table doesn´t get deleted

for example: I have a table with this 3 fields:

ID | name | last name

I create a register and its id is 1
then i create another one and its id is 2
but after that i delete both registers
and after that i create another register that is supposed to be id = 1 cause
the table is empty again
but it appear as 3 keeping the id count

any help with this?

thanks anyway