G'Day!
I found the problem, programmer error! Yep me :(
Anyways, I stripped back my code and I found that I was calling the
INSERT INTO query (which was in a separate method) before I was
loading the full list of Categories. Fixed now :)
Thanks for everyone's help!
cya
Ben
On Fri, 15 Sep 2006, at 1:10:47, Charles Calvert wrote:
On 9/13/2006 6:20 PM, Ben Blake wrote:
On Thu, 14 Sep 2006, at 6:22:41, Charles Calvert wrote:
On 9/12/2006 6:46 PM, Ben Blake wrote:
I am having trouble with inserting rows using INSERT INTO, all I
ever
get is 5 rows added!
I have created my tables and indexes (REAL SQL Database):
db.SQLExecute("create table Summary(Grp string, Cat string, Year
Integer, Month Integer, Tot Double)")
db.SQLExecute("create index Summary_idx on Summary(Grp, Cat,
Year)")
db.SQLExecute("create table Category_List(Grp string, Type
string, Cat
string, SortPriority Integer)")
Now I need to initialise the summary with zeros for each of the
Categories and Groups (makes it easier so my updating code
doesn't have
to check if the item exists or not). Using the following code
(Category_List table contains 50-60 rows) only ever insert 5 rows!
db.SQLExecute("INSERT INTO Summary select Grp, Cat, 8, 1, 0 from
Category_List")
_______________________________________________
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>
