Thank you for the advice. What about transfering the existing data to new table structure? Do you have a procedure or class that I can have to do this in RB.
--- Trausti Thor Johannsson <[EMAIL PROTECTED]> wrote: > You understand it correctly, meaning that you can > not do structural > changes with sql commands. But since sqlite is very > fast and easy > you can easily get away with it with some > workarounds. > > One is to make the new database in memory with the > new structure, > import all records into it, drop the old tables, and > connect the > database file to the in memory database, and our > laughing. > > Not as good as structure changes, but works. Also, > don't forget that > sqlite doesn't care what type the fields are. So > you could in theory > name them all varchar and then still be able to read > integers or > whatever from them. > > During my dev cycles, I just toss the database file, > create a new > one, and continue. But I create my database with > code, makes it so > much easier to do everything. > > And one but not least, do a good design to start > with. > > > Trausti > > > On Apr 27, 2006, at 8:23 PM, Long Huynh wrote: > > > I like the idea of SQLite's easy setup and lite > > Maintainant, however I need to change my data > > structures often through out the development > cycle, > > due to requirement changes. There is no easy way > to > > make modification like MySQL, so I've been still > > waiting for new MySQL driver. > > Do I not understand SQLite to make this kind of > > comment? > > > > Thanks > > _______________________________________________ > > Unsubscribe or switch delivery mode: > > <http://www.realsoftware.com/support/listmanager/> > > > > Search the archives of this list here: > > > <http://support.realsoftware.com/listarchives/lists.html> > > _______________________________________________ > Unsubscribe or switch delivery mode: > <http://www.realsoftware.com/support/listmanager/> > > Search the archives of this list here: > <http://support.realsoftware.com/listarchives/lists.html> > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
