Is it possible to execute multiple SQL statements at once?

edwinsn · 2015-10-04 09:28:47

Hi ab,

By nature many DBMS including the SQLITE3 engine supports executing multiple SQL statements delimited by commas, but it seems that both the TSQLRestServer and TSQLDBConnectionProperties do not support comma-separated SQL statements?

Thanks.

edwinsn · 2015-10-04 15:52:42

PS, it's extremely useful when upgrading an existing database if one can execute multi sql statements at a time, for example, execute a bunch of SQLs from a .sql file extracted from a db management tool.

ab · 2015-10-04 21:04:34

It is for security reasons.
And to enforce use of ORM instead of SQL.

Use a Batch ORM instead for safe and fast process.

edwinsn · 2015-10-05 08:44:32

Thanks for the explanation, ab.

I understand it that the REST server (which can be accessed remotely) should not allow multiple SQL execution at a time, but if I'm correct, at the database engine level (which for local access), this function should be exposed.

Nouba · 2015-10-05 09:42:31

AFAIK you can execute a SQL script with SQLite3 like.

YourSQLDBSQLite3ConnectionProperties.MainConnection.DB.ExecuteAll(StringFromFile(PathToScript));

edwinsn · 2015-10-05 11:30:12

Thanks @Nouba, good to know that!

mORMot Open Source

#1 2015-10-04 09:28:47

Is it possible to execute multiple SQL statements at once?

#2 2015-10-04 15:52:42

Re: Is it possible to execute multiple SQL statements at once?

#3 2015-10-04 21:04:34

Re: Is it possible to execute multiple SQL statements at once?

#4 2015-10-05 08:44:32

Re: Is it possible to execute multiple SQL statements at once?

#5 2015-10-05 09:42:31

Re: Is it possible to execute multiple SQL statements at once?

#6 2015-10-05 11:30:12

Re: Is it possible to execute multiple SQL statements at once?

Board footer