On 14-12-2018 11:15, Luuk wrote:
On 13-12-2018 18:26, Simon Slavin wrote:
On 13 Dec 2018, at 2:57pm, Carlo capaldo <carlocapa...@hotmail.com>
wrote:
UPDATE folder
SET Folder_Path = 'E:\Photos'
would change the directory references in all existing 16 rows
currently containing Folder_Path references to the wrong locations
to the correct location ‘E:\Photos’ however this also generates a
“UNIQUE constraint failed” error.
You are correct about what the command does. However, the schema of
the database (its structure, including how all its tables, indexes
and views are defined) includes the following:
CREATE UNIQUE INDEX Folder_Path ON Folder(Folder_Path);
This means that no two rows in the Folder TABLE may have the same
values for Folder_Path . I'm sure that makes sense to the person who
defined the schema, so let's look at the current values:
sqlite> .mode column
sqlite> .width 60 20
sqlite> SELECT Folder_Path,Folder_DisplayName FROM Folder;
Just because i was interested in the structure of tis SQLite db, i was
looking at the version on my computer.
sqlite> select Folder_Path, Folder_DisplayName from Folder;
Folder_Path Folder_DisplayName
----------------------- ------------------
C:\Users\Luuk2\Pictures Pictures
C:\Users\Luuk2\Pictures Camera Roll
C:\Users\Luuk2\OneDrive Afbeeldingen
C:\Users\Luuk2\Pictures Saved Pictures
C:\Users\Luuk2\OneDrive Schermopnamen
C:\Users\Luuk2\Pictures Screenshots
OK so far, no problems, but why do i get 'no collation sequence' with
this statement:
sqlite> select Folder_Path from Folder;
Error: no such collation sequence: NoCaseUnicode
sqlite>
For completenes the CREATE TABLE for this table (without indexes an
triggers):
CREATE TABLE Folder(
Folder_Id INTEGER PRIMARY KEY,
Folder_ParentFolderId INTEGER REFERENCES Folder ON DELETE CASCADE,
Folder_LibraryRelationship INTEGER,
Folder_Source INTEGER,
Folder_SourceId INTEGER REFERENCES Source ON DELETE CASCADE,
Folder_Path TEXT COLLATE NoCaseUnicode,
Folder_DisplayName TEXT COLLATE NoCaseLinguistic,
Folder_DateCreated INTEGER,
Folder_DateModified INTEGER,
Folder_KnownFolderType INTEGER,
Folder_SyncWith INTEGER,
Folder_StorageProviderFileId TEXT,
Folder_InOneDrivePicturesScope INTEGER,
Folder_ItemCount INTEGER);
sqlite> .version
SQLite 3.21.0 2017-10-24 18:55:49
1a584e499906b5c87ec7d43d4abce641fdf017c42125b083109bc77c4de48827
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
