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 <tj at quarksbar dot net> 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>
|