in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

default value for autoincrementseed should be = 1 like SQLite default AUTOINCREMENT first value

Last post 03-06-2010 8:30 AM by nolis71cu. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-06-2010 8:30 AM

    default value for autoincrementseed should be = 1 like SQLite default AUTOINCREMENT first value

    Hi Folks

     when i drag a table into a dataset using the designer, and it has an autoincrement primary key field. the created datatable in the dataset has th

    autoincrementseed = 0 , but the default first value inside SQLite is 1

    so when the DataBase is updated this fields  diferents on the dataset and on the SQLite DataBase.

    this make my DB corrupted because others tables that use the former table primary key , points to the wrong id

    so my question is. can the default value for autoincrementseed on the designer should be 1, just like SQLite use.

    thanks in advance

    Manolito

     

     

     

Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems