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