Hi Pete, Am 17.09.2012 um 18:41 schrieb Peter Haworth <[email protected]>:
> Hi Klaus, > ... > > SELECT * FROM Index WHERE Table='Persons AND Text LIKE 'sa%' JOIN Persons > on Person.<PrimaryKeyname>=Index.Key > > If you are using SQLite, your could use Triggers to keep the Index Table up > to date with any inserts, updates, or deletes from Persons so the SQL in > your program would not have to deal with it. I can give you more info on > that if you need it. thanks a lot, I might come back to you if neccessary! > Pete Best Klaus -- Klaus Major http://www.major-k.de [email protected] -- Klaus Major http://www.major-k.de [email protected] _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
