Yes, I know about that but the project I'm working on requires me to parse out all the individual elements of the CREATE statement, not actually create the table. The PRAGMA commands provide some information about the table but you have to parse the CREATE command to get the rest.
On Thu, Dec 22, 2011 at 9:06 AM, Bob Sneidar <b...@twft.com> wrote: > Open the sqLite_master table. In it you will find a column called SQL with > entries for how to create each table. > > Bob > > > On Dec 21, 2011, at 2:08 PM, Pete wrote: > > > I think I tried that but the arguments aren't always comma delimited > > unfortunately. Somewhat related,I wish SQLite provided more formatted > > access to the table structures. Some stuff is available via the PRAGMA > > statements but for other information, there's no alternative but to parse > > the CREATE TABLE statement. I think I found a series of SQL statements > > once that built the equivalent of mySQL Information tables for SQLite but > > now I can't find it! > > > > > > On Wed, Dec 21, 2011 at 1:49 PM, Bob Sneidar <b...@twft.com> wrote: > > > >> OIC good point. But wouldn't it be better simply isolate the comma > >> delimited arguments (usually in parens) in an SQL statement and then > deal > >> with them as items? But I suppose there are all kinds of special > >> circumstances that would make a general purpose word function very > unwieldy. > >> > >> Bob > >> > >> On Dec 21, 2011, at 1:17 PM, Pete wrote: > >> > >>> Not really - try parsing out an SQL SELECT statement. Granted that's > not > >>> really English text but if you want to make this a general purpose > >>> function, you have to deal with that circumstance. I needed to do that > >> and > >>> ended up going through the text and inserting a space after each comma > if > >>> there wasn't already one there. > >>> > >>> On Wed, Dec 21, 2011 at 12:54 PM, Bob Sneidar <b...@twft.com> wrote: > >>> > >>>> I suppose it could be argued that everything would break down if the > >> text > >>>> were "now,is,the,time,for,all,goo,men..." but at some point we have to > >>>> presume the absence of the absurd? to have 2 words split by a comma > is a > >>>> problem with the data, not with the software. > >>>> > >>>> Bob > >>>> > >>>> > >>>> On Dec 21, 2011, at 12:09 PM, Mark Wieder wrote: > >>>> > >>>>> Yes, but... if the phrase is "now is the time,for all good men" then > a > >>>>> search for "all" will return 5 instead of 6. > >>>>> > >>>>> -- > >>>>> -Mark Wieder > >>>>> mwie...@ahsoftware.net > >>>> > >>>> > >>>> _______________________________________________ > >>>> 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 > >>>> > >>>> > >>> > >>> > >>> -- > >>> Pete > >>> Molly's Revenge <http://www.mollysrevenge.com> > >>> _______________________________________________ > >>> 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 > >> > >> > >> _______________________________________________ > >> 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 > >> > >> > > > > > > -- > > Pete > > Molly's Revenge <http://www.mollysrevenge.com> > > _______________________________________________ > > 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 > > > _______________________________________________ > 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 > > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ 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
