Statement.toSqlExtended

string toSqlExtended(gda.connection.Connection cnc, gda.set.Set params, gda.types.StatementSqlFlag flags, out gda.holder.Holder[] paramsUsed)

Renders stmt as an SQL statement, with some control on how it is rendered.

If cnc is not null, then the rendered SQL will better be suited to be used by cnc (in particular it may include some SQL tweaks and/or proprietary extensions specific to the database engine used by cnc): in this case the result is similar to calling [gda.connection.Connection.statementToSql].

Parameters

cnca #GdaConnection object, or null
paramsparameters contained in a single #GdaSet object, or null
flagsa set of flags to control the rendering
paramsUseda place to store the list of actual #GdaHolder objects in params used to do the rendering, or null

Returns

a new string if no error occurred

Throws

[StatementException]