Reply to thread

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 !