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

Reply via email to