Hi Pete, Am 17.09.2012 um 18:41 schrieb Peter Haworth <p...@lcsql.com>:
> 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 kl...@major-k.de -- Klaus Major http://www.major-k.de kl...@major.on-rev.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
