I'm not sure if the 'string' type is managed properly by the database engine, although I doubt this have something to see with your problem. You eventually may try using 'varchar' type and see if this problem occurs again...
Damien. > -----Message d'origine----- > De : [EMAIL PROTECTED] [mailto:realbasic-nug- > [EMAIL PROTECTED] De la part de Ben Blake > Envoyé : mercredi 13 septembre 2006 00:46 > À : REALbasic NUG > Objet : Inserting multiple rows using INSERT INTO problems > > 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> > -------------------------------------------------------------------------- > ------------- > Orange vous informe que cet e-mail a ete controle par l'anti-virus mail. > Aucun virus connu a ce jour par nos services n'a ete detecte. > _______________________________________________ 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>
