small vb.net issues

[angela4eva]

i have a table that have record numbers,but record numbers are zero i want to query that table,get all the records that have a record number as zero then look at thehighest rec number and start increamenting and give the next numbers to the records with recno as zero's.Any help will be appreciated.
thanks

 

[chrissie1]

What do you have so far.

why do you not use identity or autonumber or sequence? Depending on the database.

Christiaan Baes
Belgium

"My old site" - Me

 

[angela4eva]

The data is imported,i want to keep the rec number same except for the ones with zeros that have to be given the subsequent numbers

 

[chrissie1]

Yeah I know that. But I want to see code. And what is the database you are using.

Christiaan Baes
Belgium

"My old site" - Me