Find string "xxx" in field yyy OF THIS CARD

[Bob Sneidar]

On the off chance that you are not pulling my leg, SQL is a query language intended to work with dissimilar database engines, so that a database driven application does not have to depend upon a proprietary database engine. There are other advantages, but that is the main one. 

LC provides the ability to connect to several kinds of SQL engines, as well as creating and accessing sqLite file based databases on your hard drive. Once you get the data into an SQL database (not that difficult) you can use the query language to find just about anything about the data. 

In practice there are some differences in the syntax and capabilities of different flavors of SQL, but each have resources on the web that can be used to glean the proper syntax. I resisted SQL for a long time, and still only use it in a fairly rudimentary fashion, but when working with large amounts of data, it is a great thing to learn. 

Forgive me if I took the bait and just made a fool of myself. ;-)

Bob


On Feb 3, 2012, at 12:00 PM, Francis Nugent Dixon wrote:

> Hi from BeautifulBrittany,
> 
> Merci André,
> 
> Je n'avait pas pensé à utiliser "DontSearch" !
> 
> J'aime !!
> 
> Bob,
> 
> I hadn't heard this before, and I haven't the faintest
> idea what SQL is. But I will look into it !
> 
> It seems that my knowledge is sadly lacking .........
> 
> Thanks !
> 
> -Francis
> 
> "Windows is a pane"
> _______________________________________________
> 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