is among the words AND find words

Bob Sneidar bobs at twft.com
Thu Dec 22 11:06:59 CST 2011


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




More information about the use-livecode mailing list