Can you Browse the SQLite DataBase?

[Old Dog]

Looks like you have to go into an interactive mode to use this tool......

Not so. The articles explains how to use the program within shell scripts. Additionally, sqlite allows a single SQL command to be entered on the command line as a second argument after the database name.

[UncleJohnsBand]

Not so. The articles explains how to use the program within shell scripts. Additionally, sqlite allows a single SQL command to be entered on the command line as a second argument after the database name.

Yep....you re correct......I see that now.....at the very bottom.....there was too much reading for me to go to the end.....

[zehd]

I have been too busy lately to dig in and learn the learning curve. SQL Statements just seems to make my eyes glaze over..

What I'm planing on doing is installing a GB-PVR using the MS Access DB, create my forms and queries there, and copy the SQL statements down. Then I was going to pester someone to help me get it into VB6

A while ago, You guys pointed me toward VB.net, and the links discussed here, but I couldn't find any VB6 code snippets.

I may very well slow down on my developing as I'm changing jobs, and will have less time surfing and coding...

Oh well...

One specific question I have is: What I've seen seems to be something like, open DB, access record, change record, save record, save DB. That would appear that a query doesn't access the sqlite DB directly, but rather a temp file, and then writes the temp file out after.

That seems that there isn't actually sharing of the data.

Is that correct?

[zehd]

I just checked out this site...

http://msdn.microsoft.com/vbrun/vbfusion...qlexpress/

It allows for installing their SQL express, and still let you hook in with VB6. I wonder if after I write something that works with the SQL Express, how difficult would it be to change the datasource to GB-PVR's SQLite database?

[UncleJohnsBand]

I have been too busy lately to dig in and learn the learning curve. SQL Statements just seems to make my eyes glaze over..

What I'm planing on doing is installing a GB-PVR using the MS Access DB, create my forms and queries there, and copy the SQL statements down. Then I was going to pester someone to help me get it into VB6

A while ago, You guys pointed me toward VB.net, and the links discussed here, but I couldn't find any VB6 code snippets.

I may very well slow down on my developing as I'm changing jobs, and will have less time surfing and coding...

Oh well...

One specific question I have is: What I've seen seems to be something like, open DB, access record, change record, save record, save DB. That would appear that a query doesn't access the sqlite DB directly, but rather a temp file, and then writes the temp file out after.

That seems that there isn't actually sharing of the data.

Is that correct?

I know that the SQL statments are not 100% compatable between Access and SQLite.

[Pioneer4x4]

I think I have everything working the way "I" like.

I have this in my "PostUpdateEPG.bat"
sqlite3 gbpvr.db3 <testupdate.sql


And this is the contents of "testupdate.sql"

UPDATE PROGRAMME
SET sub_title=SUBSTR(unique_identifier,-4,4)||' - '||sub_title WHERE (SUBSTR(sub_title,1,1)>"9" OR sub_title='') AND unique_identifier <"F";

What it does is:
changes the sub_title (episode name) field to start with the last 4 digits of the unique_identifier only if it is an "Episode" not "Show" or "Movie" or "Sports" and only if it doesn't already start with a number.

Then Turkey's File Renaming Utility: AddEpisode will rename the .mpg to filename with sortable episode number and name.