Are you saying that an Alter Table command will create a second record with the alter table syntax in it? I didn't know that. It throws a bit of a wrench in my works, but then again the best practices for sqLite table mods is to create a new table with the new structure from scratch and port the old data in from the old table. There are a lot of things you cannot do with Alter Table in sqLite, as was discussed in another thread, so maybe this is a non-starter anyway.
Bob On Jan 6, 2011, at 11:11 AM, Ruslan Zasukhin wrote: >> This will give me all the Create Table syntax for every table in the sqLite >> database I access. > > I see, Bob, > > You are using sqlite_master system table to extract original > create table ... command > > Interesting, if this is changed on any ALTERs ... > Although it seems there is no alters ... > > > -- > Best regards, > > Ruslan Zasukhin > VP Engineering and New Technology > Paradigma Software, Inc _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
