--- T&B <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > It appears that you can set > > > > PRAGMA writable_schema=ON; > > > > Then do a manual UPDATE of the sqlite_master table to insert > > > I tried it and it seems to work. But it is dangerous. If you mess > > up, you corrupt the database file. > > Now that is interesting. I didn't realize we could change > sqlite_master directly, but have often thought it could be very handy. > I've often read from it (ie select from sqlite_master), but not > written (ie update or insert).
Even if you got the sqlite_master table entries right, the in-memory sqlite schema data structures would not be in sync. You'd be better off using the normal DROP/CREATE SQL statements and published sqlite APIs to do this sort of thing. ____________________________________________________________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------