Execute SQL script
#1
Hello,

I Have this SQLite script:

Code:
update [movie]  
set c00 = (select p.strpath  from path p inner join [files] f on p.idPath = f.idPath and f.idfile = movie.idfile);

update [movie]
set c00 = replace(c00,'X:\Documentarios\','');

update [movie]
set c00 = replace(c00,'X:\Filmes\','');

update [movie]
set c00 = replace(c00,'\','');

And I want somehow execute it after a sucess movie scrap or by a keybind.

Any help?

Regards.
Reply

Logout Mark Read Team Forum Stats Members Help
Execute SQL script0