i dont know how to deal with this error. i have 4 tables. each with equal and same columns. all tables have more than 10 records. when i fire a query to find out maximum records , it shows only 9. datatype used is varchar. and since this is very crucial
as it is used as primary key and its a student id which gets incremented every time a new student adds to the 4 tables(in vb.net). my whole project is stuck cos of this. if i get this i have no other work to complete for my project.it will be over.
front end is vb.net
back end is sql.
i want that everytime when user inserts an entry and press a button,he should get student id + 1 from the existing.but it is only showing me 9records and always there's a ambiguity of 10th record in database..
guys pls help out of this!!!!
View Complete Post