is among the words AND find words

Pete pete at mollysrevenge.com
Thu Dec 22 11:34:26 CST 2011


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 <bobs at 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 <bobs at 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 <bobs at 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
> >>>>> mwieder at ahsoftware.net
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> use-livecode mailing list
> >>>> use-livecode at 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 at 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 at 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 at 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 at 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>


More information about the use-livecode mailing list