On 15/02/2006, at 12:05 AM, Marco Bambini wrote:
As far as I know (I am not an SQL guru) there isn't any restriction
in the complexity of select, but (from sqlite web site):
The number of columns in the result of the SELECT must exactly
match the number of columns in the table if no column list is
specified, or it must match the number of columns name in the
column list. A new entry is made in the table for every row of the
SELECT result. The SELECT may be simple or compound. If the SELECT
statement has an ORDER BY clause, the ORDER BY is ignored.
Please take a look here:
http://www.sqlite.org/lang_insert.html
and here:
http://www.sqlite.org/lang_attach.html
Hi Marco,
Yes, you were spot on :-) I used memDB.ErrorMessage to debug and it
was an issue regarding the number of columns.
All working perfectly now!
I haven't calculated the speed increase exactly yet - but the 45
seconds would now be under 2 seconds for sure - Perfect!
Thanks again - I'll make it up to you and buy some of your software
in the near future :-)
Cheers
Jeff
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
