Germany
Hi all,
quick question:
under which circumstances is the database TVDatabaseV21.db3 locked during runtime of MP ?
- The whole time ? (unlikely, I managed to update during runtime of MP)
- during EPG import ? ( Likely, but is the lock exclusive or on record base ?)
Background is, I add some programs not covered by any EPG, manually to the TVDatabaseV21.db3. I use sqlite3.exe and some SQL- script during runtime of MP. Up to now I could not encounter any problems. But generally when 2 programs access the same DB, trouble is ahead.
Thanks
/Gerd
BTW, if there is a VB- Script Guru around:
Why does this not work ? :
Set objshell = (Wscript.... )
objshell.run "sqllite3.exe TVDatabaseV21.db3 <AddTVGuide.sql", 1, true
Directories are set correct.
This work perfect on the commandline, it works also up to "objshell.run "sqllite3.exe TVDatabaseV21.db3" , but when the redirected input file "<AddTVGuide.sql" comes into place, nothing works any more.
Or does somebody have an idea how I could tell sqllite3.exe to execute some SQL commands directly within the script ? Couldn't find any commandline option.
Thanks for any response !
quick question:
under which circumstances is the database TVDatabaseV21.db3 locked during runtime of MP ?
- The whole time ? (unlikely, I managed to update during runtime of MP)
- during EPG import ? ( Likely, but is the lock exclusive or on record base ?)
Background is, I add some programs not covered by any EPG, manually to the TVDatabaseV21.db3. I use sqlite3.exe and some SQL- script during runtime of MP. Up to now I could not encounter any problems. But generally when 2 programs access the same DB, trouble is ahead.
Thanks
/Gerd
BTW, if there is a VB- Script Guru around:
Why does this not work ? :
Set objshell = (Wscript.... )
objshell.run "sqllite3.exe TVDatabaseV21.db3 <AddTVGuide.sql", 1, true
Directories are set correct.
This work perfect on the commandline, it works also up to "objshell.run "sqllite3.exe TVDatabaseV21.db3" , but when the redirected input file "<AddTVGuide.sql" comes into place, nothing works any more.
Or does somebody have an idea how I could tell sqllite3.exe to execute some SQL commands directly within the script ? Couldn't find any commandline option.
Thanks for any response !