Android multiline SQLite command

Question

If you have a string representation of a multiline SQLite command, is there any way to execute without looping through each command. IE sqLiteDatabase.execSQL(statement)

Have you tried executing the commands separated by semicolons (;)? — coproc
– coproc, Commented Jan 11, 2013 at 21:47

Sam · Accepted Answer · 2013-01-11 22:05:20Z

2

You must call each command separately.
I assume you are just double-checking, but the execSQL() documentation is quite clear:

Parameters
sql the SQL statement to be executed. Multiple statements separated by semicolons are not supported.

The same is true for the matching rawQuery() method:

Parameters
sql the SQL query. The SQL string must not be ; terminated

edited Jan 11, 2013 at 22:05

answered Jan 11, 2013 at 21:54

Sam

87k21 gold badges185 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android multiline SQLite command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related