On Fri, 23 Jul 2004 18:50:49 +0200, you wrote: > >> How do you renumber an index anyway? > >Hmm ... given the tables > work (idx, sortcrit) > storeroom(rowcount integer) > >where 'idx' may be the index to renumber and 'sortcrit' a sorting criteria. > >I would try to do something like the code below, but I just remembered that >sqlite doesn't support recursive triggers, therefore this won't work :(
So much for theory, I guess the only way is to write a custom function.. On a side note, is there a repository of user written functions somewhere that I can browse? Thanks Randall Fox