Re: [sqlite] Brain error

2008-06-23 Thread Christophe Leske
> Use actual field names in lookup table for idField, xField and yField. > Thank you! -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Brain error

2008-06-23 Thread Igor Tandetnik
Christophe Leske <[EMAIL PROTECTED]> wrote: > can someone remember me how to fill in a rtree table with values from > another table? > > Something like > > insert into lookup (select id, x,y from othertable) -- this doesnt > work btw insert into lookup(idField, xField, yField) select id, x, y