Reply to thread

Message

<blockquote data-quote="Aquarius" data-source="post: 206239" data-attributes="member: 10507">Hi all,quick question:under which circumstances is the database TVDatabaseV21.db3 locked during runtime of MP ?- The whole time ? (unlikely,&nbsp; 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/GerdBTW, if there is a VB- Script Guru around:Why does this not work ? :Set objshell = (Wscript.... ) objshell.run &quot;sqllite3.exe TVDatabaseV21.db3 &lt;AddTVGuide.sql&quot;, 1, trueDirectories are set correct. This work perfect on the commandline, it works also up to &quot;objshell.run &quot;sqllite3.exe TVDatabaseV21.db3&quot; , but when the redirected input file &quot;&lt;AddTVGuide.sql&quot; comes into place, nothing works any more.Or does somebody have an&nbsp; 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 !</blockquote>

[QUOTE="Aquarius, post: 206239, member: 10507"] 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 ! [/QUOTE]

Verification