PDA

View Full Version : SQLite


patrick6
03-19-2004, 01:49 PM
I have been fooling around with the SQLite plug in by changing around the tmeplate provided, etc.
The problem I am having is adding fields to the databse. I can add the place to input them and display them.

How do I add the "columns" so to speak to the db?

Thanks,
Patrick

Worm
03-19-2004, 01:58 PM
This is in the Projects/Actions/On Startup. It is the code that creates the database.


SQLite.Query(db,"CREATE TABLE Websites(RecordID integer primary key, Name text, URL text, Username text, Password text)");