--- 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]
-----------------------------------------------------------------------------
