[sqlite] How to inject primary keys which are set to autoincrement in sqlite??

2010-09-10 Thread Anthony Main
In MS SQL I would use SET IDENTITY INSERT ON How do I do something similar in SQLite. I am trying to upgrade a database and want to maintain the IDs from the original Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] How to inject primary keys which are set to autoincrement in sqlite??

2010-09-10 Thread Anthony Main
In MS SQL I would use SET IDENTITY INSERT ON How do I do something similar in SQLite. I am trying to upgrade a database and want to maintain the IDs from the original Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How to inject primary keys which are set to autoincrement in sqlite??

2010-09-09 Thread Simon Davies
On 9 September 2010 12:22, tigermain wrote: > > In MS SQL I would use > > SET IDENTITY INSERT ON > > How do I do something similar in SQLite. I am trying to upgrade a database > and want to maintain the IDs from the original You choose whether to include the key as part of

[sqlite] How to inject primary keys which are set to autoincrement in sqlite??

2010-09-09 Thread tigermain
In MS SQL I would use SET IDENTITY INSERT ON How do I do something similar in SQLite. I am trying to upgrade a database and want to maintain the IDs from the original Thanks -- View this message in context:

[sqlite] How to inject primary keys which are set to autoincrement in sqlite??

2010-09-09 Thread tigermain
In MS SQL I would use SET IDENTITY INSERT ON How do I do something similar in SQLite. I am trying to upgrade a database and want to maintain the IDs from the original Thanks -- View this message in context: