Using SQLite

[wordmuse]

After buying a new computer, I need to change the attribute of hundreds of local URLs to match the path on my computer.

I am trying to understand what is written here:
http://kinook.com/Forum/showthread.php?t=2825

But I don't understand it.

If my old path was something like:

c:\olduser\documents\urpfiles
and the new path is
c:\currentuser\documents\urpfiles

I get that I'm supposed to use this command with SQLLite:

-.-.-.-.-.-.-.-.-.-.-.-

Change an absolute path in all URL item attributes to a relative path:

UPDATE ItemAttribute SET Value = Replace(Value, 'D:\MyFolder\', '') WHERE AttributeID = 996 AND Value LIKE 'D:\MyFolder\%';

-.-.-.-.-.-.-.-.-.-.-.-

So what would be the exact command I'm supposed to use? Where do "olduser" and "currentuser" go in this command?

And hitting the nail on the head: this would do the replacing in the URL attribute?

Thanks.
- Bal

[kinook]

Yes, the command updates the URL attribute. That command converts an absolute path to a relative one by removing the D:\MyFolder\ prefix on paths like D:\MyFolder\abc\xyz.txt to be just abc\xyz.txt -- if the .urd file is in D:\MyFolder, UR will handle the relative path abc\xyz.txt automatically so that it won't have to be changed if the .urd file and linked files in that folder or subfolder are moved.
http://www.kinook.com/UltraRecall/Manual/foldersynchronization.htm

If you actually want to replace one absolute path with a different absolute path, use something like the next command (Change all URLs...) to do the replacement:

UPDATE ItemAttribute SET Value = 'c:\currentuser' || substr(Value, 10, 2000) WHERE AttributeID = 996 AND Value LIKE 'c:\olduser%';