mORMot Open Source

squirrel

Member

Registered: 2015-08-13

Posts: 165

Run sql statement unprepared

Is there a way to specify that a specific sql statement should not be executed prepared?  In Mysql, some statements should not be prepared and causes Mysql to return:
This command is not supported in the prepared statement protocol yet (1295)
In these limited instances, it would be useful to be able to directly execute the statement without preparing

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,509

Website

Re: Run sql statement unprepared

From the ORM? Or via direct SQL?

Which mormot.db unit do you use to connect to MySQL?

squirrel

Member

Registered: 2015-08-13

Posts: 165

Re: Run sql statement unprepared

Direct SQL
mormot.db.sql, mormot.db.sql.odbc and for another project mormot.db.rad.firedac