KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm using FMDB to create a SQLite database on iPhone. I have a initial.sql that is of the form CREATE TABLE Abc ... ; CREATE TABLE Def ... ; I load this by loading the file into an NSString and running it NSString * str = // string from file initial.sql [db executeUpdate: str]; This succeeds but later on I get a failure: no such table: Def It's clear that the second statement is not being called. How can I do this so that all of the queries will be called? According to the SQLite documentation: "The routines sqlite3_prepare_v2(), sqlite3_prepare(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_exec(), and sqlite3_get_table() accept an SQL statement list (sql-stmt-list) which is a semicolon-separated list of statements." So, this should all work.
Tags (comma-separated)
Save Edits
Cancel