Hi Joe,
Even if you got the sqlite_master table entries right, the in- memory sqlite schema data structures would not be in sync.
Yes, but my point/question was, would that not only apply to tables and indexes? I expect that views and triggers have no data structures (eg rootpage = 0) so there's nothing to get out of sync.
You'd be better off using the normal DROP/CREATE SQL statements and published sqlite APIs to do this sort of thing.
Ideally, yes. But I've come across a few situations (such as the one I gave as an example) where being able to write to the sqlite_master tables would permit a solution that could be done totally in SQL, or which would save parsing schema.
Thanks, Tom ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
