T&B <[EMAIL PROTECTED]> wrote: > >> Now that is interesting. I didn't realize we could change > >> sqlite_master directly, but have often thought it could be very > >> handy. > > > > Warning: If you mess up, your database becomes unreadable and > > unrepairable. This is a very dangerous feature. If you use it and > > you lose data: no tears. > > Let me clarify. What I'm asking is whether editing the view and > trigger entries in sqlite_master is safer than editing table and > index entries (see below). >
No. Any mistake, however slight, in either triggers or views, will probably leave the database unreadable and unrepairable. SQLite is unforgiving of errors in the sqlite_master table. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------