[sqlite] Tidy Up Schema

I would like to tidy up the schema's of a few tables. At the moment all of the fields run together on the same line, i.e. something like this: sqlite> .schema materials CREATE TABLE Materials (MaterialType varchar(10) not null, MaterialCode varchar( 10) not null, Description

[sqlite] Tricky SQL Statement

I wonder if someone could please help me with a tricky SQL statement that I'm trying to create in SQLite. I have four tables: Charts, Colours, MaterialTypes, Materials. There is a one-to-many relationship between the Charts and Colours (i.e. each Chart can have 0 or more Colours). There is a

[sqlite] Handling database updates in my program updates

I'm creating a shareware program using Visual Basic and SQLite. I'm using the SQLiteDB wrapper. I want to plan how I am going to handle updates to my program that involve modifing the database, and thus I'd like some advice as I'm sure others have faced this problem before. I need to be

RE: [sqlite] sqlite with Visual Basic

Murray   You might want to check out: http://dickinson.basicguru.com/ and navigate /software.htm and ddoc at US$25, which works with three languages.  If you use Powerbasic, then you get source code as well. Don also has a PB interface to SQLite   David >>> Murray Moffatt <[EMAIL PROTE

Re: [sqlite] sqlite with Visual Basic

Hi Wind, At 13:02 17/05/2004 +0800, you wrote: You have two choose: 1. search the windows register for the datasource that you created using ODBC Control Panel, you can create the same register entry programmatically. 2. You can just use such a string as your ConnectionString

RE: [sqlite] sqlite with Visual Basic

Hi Greg, Many thanks for your reply to my questions. I had a quick look at ActiveReports but once I saw the $499 price tag I didn't bother going any further. That's way too much to spend on my little freeware program! The only reason I was looking at Crystal Reports is because I already have