I'd be inclined to have a handler to execute/buffer the SQL statements
based on what type of db is in use.
For example you could have a handler dbCommand which took SQL statements as
a parameter. If the DB is SQLite, the handler would execute the statement
immediately. If some other version of S
which fields you do a morphing of the data in - so
that it's easier to remember in a years time ;) - if necessary!
Hope that helps a bit,
Dave
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/thinking-through-parsing-multi-line-database-commands-with-cr-
I'm still kind of thinking aloud on this, and don't want to shoot my foot
clean off.
I'm developing with the ipad version in mind for the future, too.
My preferred db will be postgres, with mysql as an alternate (if I don't
keep tripping across it's "whoops!"s). However, for performance reasons