Re: [sqlite] Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "may not be NULL"

On 03/03/2011, at 11:53 AM, Rami Abughazaleh wrote: > Trying to insert a new row in a table that has a column specifically set to > the rowid data type There is no rowid data type. To alias rowid you need to just type it as integer primary key. > will cause an error message like "value cannot

[sqlite] Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "may not be NULL"

Hi. Trying to insert a new row in a table that has a column specifically set to the rowid data type will cause an error message like "value cannot be null". CREATE TABLE [test] ( [Id] ROWID NOT NULL, [Name] nvarchar(50) NOT NULL, [Value] nvarchar(256) NOT NULL ); INSERT INTO test