Struct PreparedImpl

Encapsulation of a prepared statement.

Commands that are expected to return a result set - queries - have distinctive methods that are enforced. That is it will be an error to call such a method with an SQL command that does not produce a result set.

Constructors

Name	Description
`this`	Submit an SQL command to the server to be compiled into a prepared statement.

Properties

Name	Type	Description
`numArgs` [get]	`ushort`	Gets the number of arguments this prepared statement expects to be passed in.
`preparedFieldDescriptions` [get]	`FieldDescription[]`	Gets the prepared header's field descriptions.
`preparedParamDescriptions` [get]	`ParamDescription[]`	Gets the prepared header's param descriptions.

Methods

Name	Description
`exec`	Execute a prepared command.
`getArg`	Prepared statement parameter getter.
`opAssign`
`query`	Execute a prepared SQL command for the case where you expect a result set, and want to deal with it one row at a time.
`queryRow`	Executes a one-off SQL command and returns the first row received, or null if none. Useful for the case where you expect a (possibly empty) result set, and you're either only expecting one row, or only care about the first row.
`queryRowTuple`	Execute a prepared SQL command to place result values into a set of D variables.
`querySet`	Execute a prepared SQL command for the case where you expect a result set, and want it all at once.
`queryValue`	Executes a one-off SQL command and returns a single value: The the first column of the first row received. Useful for the case where you expect a (possibly empty) result set, and you're either only expecting one value, or only care about the first value.
`release`	Release a prepared statement.
`setArg`	Prepared statement parameter setter.
`setArg`
`setArgs`	Bind a tuple of D variables to the parameters of a prepared statement.
`setArgs`	Bind a Variant[] as the parameters of a prepared statement.
`setNullArg`	Sets a prepared statement parameter to NULL.

Aliases

Name	Description
`queryResult`	Execute a prepared SQL command for the case where you expect a result set, and want it all at once.
`querySequence`	Execute a prepared SQL command for the case where you expect a result set, and want to deal with it one row at a time.
`queryTuple`	Execute a prepared SQL command to place result values into a set of D variables.

Authors

Copyright

License