Hi Mark, I am not an expert on SQLite.
But I have programming experience, so I can make a suggestion. You did not say what application you are talking and if you did, I might not know about it. What I would do is yes create a simple application that accesses the SQLite database and the table you modified. I would go back to the unmodified table, this way you would not worry about the position of the added column. I would either add a new table to the database in which I would have an Id key plus a reference key to the id key of the original table records and the columns you want to add to put the added info. Your simple application would have two modes one for adding the info in the second table and the second mode to display with a query, the info from both tables That all depend on what you have to create that small application. Messing with the original is not a good idea but no problem with another table and even in another database. You just have to know how. Hope this help’s Guy -----Original Message----- From: CDN Mark Sent: Tuesday, December 07, 2010 5:31 AM To: General Discussion of SQLite Database Subject: [sqlite] database question Hi, newbie question, what I'd like to do is improve/add columns for a sadly lacking database for a commercial proramme. What I'd like to know is it possible to add columns to an existing database without causing problems, add extra info into these columns, and then somehow create a viewer of the database.. It woud have to only be a straight viewer, no editing features needed. I did add a column, I think successfuly, but it went before the primary key column, does this matter? Well, you can always ask mtia Mark _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
