On May 15, 2011, at 9:44 PM, romtek wrote: > An analogy: if > I want to create a letter with pretty styles and maybe images, I will use MS > Word or, at least, Open Office. I will not write a program to do that :)
Wrong analogy above. The correct analogy would be, if you had to modify MS Word so that when you hit Cmd-B, instead of making the selected text bold, MS Word would remove every alternate character from the selection and render the result in italics, well, then you would have to delve into the code of MS Word and do some major surgery to it. Changing the database structure is not the same as adding images... you can do the latter with various GUI-based tools. Changing the database structure is modifying the way your information is stored. It can really bugger up your application that depends on the database. Before you set your database in stone, you need to think through the design, draw it out on a piece of paper, match its fields with your application, etc. Once the db is designed and populated, you have other tools such as ALIAS and VIEW that allow you to make the db tables appear as you may want them. Sure, there may be instances when you just have to change a column name. Well, you can do that, but with some difficulty, as shown by the solutions provided by various users. Good luck. Puneet. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users