On Tue, May 20, 2008 at 6:57 AM, Ralf Junker <[EMAIL PROTECTED]> wrote:
> This should NOT happen as SQLite usually rejects duplicate rowids with a
constraint error.
For this table, the badly-named column "RowID" is actually a text field
that's allowed to be null, not a primary key.
-- Describe NDXPARAMVALUES_LOCALIZEDSTRING
CREATE TABLE 'ndxParamValues_LocalizedString'
(
'FamilyId' INTEGER NOT NULL ,
'ParamId' INTEGER NOT NULL ,
'RowID' TEXT COLLATE NOCASE,
'Index' INTEGER ,
'Value' INTEGER NOT NULL
)
Brad Town
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
