G'Day
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")
Oddly enough, the 5 rows all have the same Grp...
Any ideas on this on why this is happening? Or a better way to insert
all the zeros?
cya
Ben
_______________________________________________
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>
