computeDmlStatements

Creates an INSERT, an UPDATE and a DELETE statement from a SELECT statement using the database metadata available in cnc's meta store. Each statements are computed only if the corresponding place to store the created statement is not null.

bool

(

gda.connection.Connection cnc

gda.statement.Statement selectStmt

bool requirePk

gda.statement.Statement insertStmt = null

gda.statement.Statement updateStmt = null

gda.statement.Statement deleteStmt = null

)

Parameters

cnc gda.connection.Connection: a #GdaConnection
selectStmt gda.statement.Statement: a SELECT #GdaStatement (compound statements not handled)
requirePk bool: TRUE if the created statement have to use a primary key
insertStmt gda.statement.Statement: a place to store the created INSERT statement, or null
updateStmt gda.statement.Statement: a place to store the created UPDATE statement, or null
deleteStmt gda.statement.Statement: a place to store the created DELETE statement, or null

Return Value

Type: bool

true if no error occurred

Throws

ErrorWrap