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
