shouldn't leafID be the primary key of your LEAVES table and thus already
indexed?  What does your create table statement look like?  I'd expect

CREATE TABLE Leaves (LeafID INTEGER PRIMARY KEY AUTOINCREMENT, ... other
columns ... )

As far as the create index failing, no idea there, sorry..

Sam


On Fri, Feb 29, 2008 at 12:23 PM, Mark Gilbert <[EMAIL PROTECTED]> wrote:

> Hey Samuel
>
> Thanks for your ideas.
>
> In fact we stumbled across the solution, and I am amazed we didnt
> think of it earlier, and no-one suggested it.  Basically our LEAVES
> table doesn't have an Index !!
>
>


-- 
-----------------------------------------------------------------
We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer.
 Position is in the Washington D.C. metro area. Contact
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to