BareFeet wrote: > The one hurdle I've struck is how to send a multi-statement SQL > command. Say for instance I want to process a bunch of text such as: > > How do I submit it via C functions?
You run the statements one at a time. sqlite3_prepare et al helpfully provide a pointer to the first character past the first complete statement. > It seems that I need to use sqlite3_get_table() to get the result in > one hit, rather than sqlite3_prepare_v2 and stepping through each row. > Is that right? What's wrong with stepping through each row? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
