Database Problem....
-
Hi all I was creating a Web form, by which the data will stored into a ms-access database table. In my database table there is a field ID which is autonumber but my id is not generated properly while working with the database, currently the values for ids are: - 1,2,3,6,7,13,15,16,30,34,35…. Means the ids are not generated into correct manner, What should I do for that. Plz reply , Thanks in advance.
-
Hi all I was creating a Web form, by which the data will stored into a ms-access database table. In my database table there is a field ID which is autonumber but my id is not generated properly while working with the database, currently the values for ids are: - 1,2,3,6,7,13,15,16,30,34,35…. Means the ids are not generated into correct manner, What should I do for that. Plz reply , Thanks in advance.
Dont repost your query. :mad: It has already been answered
-
Dont repost your query. :mad: It has already been answered
Sorry for reposting the problem, but there is no delete operation will performe there i checked it for the same even there delete keyword available in my web form so how could it will be deleted.
-
Hi all I was creating a Web form, by which the data will stored into a ms-access database table. In my database table there is a field ID which is autonumber but my id is not generated properly while working with the database, currently the values for ids are: - 1,2,3,6,7,13,15,16,30,34,35…. Means the ids are not generated into correct manner, What should I do for that. Plz reply , Thanks in advance.
this occur may be you deleted some records for example you 10 rows that has auto generated column you have deleted the i & 10 th record and if you insert the new row the autogenerated column will take 11 as the new record coz of built-in storedprocedure will do this. you have to drop and recreate you table to solve this problem
Thanks Warm Regards Prakash-B
-
this occur may be you deleted some records for example you 10 rows that has auto generated column you have deleted the i & 10 th record and if you insert the new row the autogenerated column will take 11 as the new record coz of built-in storedprocedure will do this. you have to drop and recreate you table to solve this problem
Thanks Warm Regards Prakash-B
but there is no delete operation will performe there i checked it for the same even there delete keyword available in my web form so how could it will be deleted.
-
Hi all I was creating a Web form, by which the data will stored into a ms-access database table. In my database table there is a field ID which is autonumber but my id is not generated properly while working with the database, currently the values for ids are: - 1,2,3,6,7,13,15,16,30,34,35…. Means the ids are not generated into correct manner, What should I do for that. Plz reply , Thanks in advance.