On Thu, 6 May 2004, Puneet Kishor wrote:..
Things that SQLite sucks at (if you pardon the expression) compared to Access and FMPro -- ALTERing tables is a royal pain in the behind. I am constantly in need of ALTERing the tables and queries (views) as I am developing the application, and to do this is just... well, not nice.
I assume you have a copy of the source schema in a seperate file. All I do is: 1 Update source schema. 2 Compile schema into application. 3 Re-init the database using the new schema, having blown away the old database.
If you have data you want to keep in step 3, write a migration tool to
Thanks Christian, for the suggestions. However, I was not really looking for ways to do this. I already am able to do this somewhat similarly knowing what I know -- a Perl script that does it for me.
What I was saying is that SQLite doesn't offer this capability within itself with a simple ALTER command. And that makes it cumbersome.
That's all.
Thanks anyway.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
