Re: [sqlite] C# SQLiteCommandBuilder how to return AutoIncrement

2012-03-05 Thread Pawl
Christoph Kukulies wrote: > > Just a guess: I don't see any Commit or surrounding Transaction. > I don't know what do you thing this. Is any problem in definition DDL? Describe problem: After inserting (successful) autoincrement column have still zero value. It is problem for next processing.

Re: [sqlite] C# SQLiteCommandBuilder how to return AutoIncrement

2012-03-05 Thread Christoph P.U. Kukulies
Am 06.03.2012 07:34, schrieb Pawl: Hi, I Table def: - CREATE TABLE [vyroba] ( [ID_VYROBA] INTEGER PRIMARY KEY AUTOINCREMENT, [vlozeno] TIMESTAMP DEFAULT (datetime('now','localtime')), [POPIS] TEXT NOT NULL, [prefix_dmc] TEXT NOT NULL, [kistler_prog1] INT NOT NULL,

[sqlite] C# SQLiteCommandBuilder how to return AutoIncrement

2012-03-05 Thread Pawl
Hi, I Table def: - CREATE TABLE [vyroba] ( [ID_VYROBA] INTEGER PRIMARY KEY AUTOINCREMENT, [vlozeno] TIMESTAMP DEFAULT (datetime('now','localtime')), [POPIS] TEXT NOT NULL, [prefix_dmc] TEXT NOT NULL, [kistler_prog1] INT NOT NULL, [kislter_prog2] INT, [ID_PLC_PROG]