INSERT is supposed to handle multiple rows for VALUES. for example, INSERT INTO table(digit,dialpadstr) VALUES (2,'abc'), (3,'def'), (4,'ghi'), (5,'jkl'), (6,'mno'), (7,'pqrs'), (8,'tuv'), (9,'wxyz');
currently, sqlite only handles 1 row. INSERT INTO table(digit,dialpadstr) VALUES (2,'abc'); -- Jim Michaels j...@jimscomputerrepairandwebdesign.com http://JimsComputerRepairandWebDesign.com http://JesusnJim.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
