Re: [sqlite] Brain error

Igor Tandetnik wrote: > 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, x

Re: [sqlite] Brain error

> 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

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 from