SQL question

[Klaus on-rev]

Hi Pete,

Am 17.09.2012 um 18:41 schrieb Peter Haworth <pete at 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
klaus at major-k.de
--
Klaus Major
http://www.major-k.de
klaus at major.on-rev.com