Hi Ryan,
Sorry for the late reply and fully understood on the need to strip attachments for obvious reasons. While I’ve been working out which file service I can upload the file to one of your users kindly provided an excellent suggestion which I’ve been studying and reading up on to try and modify so as to try and fix all of the incorrect directory references (but so far failed to achieve!). Kind regards, Carlo. ________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of R Smith <ryansmit...@gmail.com> Sent: Friday, November 30, 2018 1:43:49 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App Hi Carlo, Attachments are stripped on this forum - could you use a file service or upload it somewhere? Also be clear about the which paths all changed and to what - AND make a backup of the file before fixing it - but there most certainly is some SQL that will fix what you described. Cheers, Ryan On 2018/11/29 9:32 PM, Carlo capaldo wrote: > Dear Users, > > Windows 10 Photos App is no longer able to find my files when opening the app. > I discovered that the App uses Sqlite and using DB Browser for SQLite I was > able to display the Table folder which shows the many different folder paths > I believe the App is referencing (see attached). > > The original folder paths have all changed and the photos etc have been > consolidated into a single directory (E:\Photos). > > I tried using the following sql commands to change the folder references for > each entry. The sequence appears to execute correctly but I can’t find a way > to update or write the database. > > select folder.Folder_Path, > replace(Folder_Path,'C:\Users\carlo\Pictures','E:\Photos') > from Folder > where folder.Folder_Id = 1 > > Could someone kindly educate me on how to update the folder references? > > Kind regards, > Carlo. > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users