Re: [SQL] tree-structured query

2006-09-30 Thread Ragnar
On fös, 2006-09-29 at 15:00 -0700, chester c young wrote: > in a simple tree structured table > > table t( > id primary key, > pnt_id references t( id ), > name > ); > > does anyone know an easy howbeit sneaky way of determining ancestory > and decendency without recursive functions, how a

[SQL] How to FindNearest

2006-09-30 Thread Alexander Ilyin
How to implement the functionality similar to the BDE/Paradox TTable.FindNearest? Suppose we have huge table. On the screen we need to show contents of that table in the Grid and under that Grid user can input in TextBox some letters. OnChange of this TextBox we need to make current row selecti