Struct odbc_safe::Statement
[−]
[src]
pub struct Statement<'con, 'param, C = NoCursor, A = Unprepared> { /* fields omitted */ }
A Statement
is most easily thought of as an SQL statement, such as SELECT * FROM Employee
.
- The statement's state
- The current statement-level diagnostics
- The addresses of the application variables bound to the statement's parameters and result set columns
- The current settings of each statement attribute
Methods
impl<'con, 'param, S, A> Statement<'con, 'param, S, A>
[src]
fn as_raw(&self) -> SQLHSTMT
Provides access to the raw ODBC Statement Handle
fn bind_input_parameter<'p, T: ?Sized>(
self,
parameter_number: SQLUSMALLINT,
parameter_type: DataType,
value: Option<&'p T>
) -> Return<Statement<'con, 'p, S, A>, Statement<'con, 'param, S, A>> where
T: CDataType,
'param: 'p,
self,
parameter_number: SQLUSMALLINT,
parameter_type: DataType,
value: Option<&'p T>
) -> Return<Statement<'con, 'p, S, A>, Statement<'con, 'param, S, A>> where
T: CDataType,
'param: 'p,
Binds a parameter to a parameter marker in an SQL Statement
Result
This method will destroy the statement and create a new one which may not outlive the bound
parameter. This is to ensure that the statement will not derefernce an invalid pointer
during execution. Use reset_parameters
to reset the bound parameters and increase the
'param
lifetime back to 'static
.
Arguments
parameter_number
- Index of the marker to bind to the parameter. Starting at1
parameter_type
- SQL Type of the parametervalue
- Reference to bind to the marker
fn reset_parameters(self) -> Statement<'con, 'static, S, A>
Unbinds the parameters from the parameter markers
impl<'con, 'param, C, A> Statement<'con, 'param, C, A> where
C: CursorState,
[src]
C: CursorState,
fn num_result_cols(&self) -> Return<SQLSMALLINT>
Returns the number of columns of the result set
See SQLNumResultCols
fn fetch(
self
) -> ReturnOption<Statement<'con, 'param, Positioned, A>, Statement<'con, 'param, NoCursor, A>>
self
) -> ReturnOption<Statement<'con, 'param, Positioned, A>, Statement<'con, 'param, NoCursor, A>>
Advances Cursor to next row
See SQLFetch See Fetching a Row of Data
fn close_cursor(
self
) -> Return<Statement<'con, 'param, NoCursor>, Statement<'con, 'param, C, A>>
self
) -> Return<Statement<'con, 'param, NoCursor>, Statement<'con, 'param, C, A>>
Closes the cursor. Cursors only need to be closed explicitly if the Statement handle is intended to be reused, but a result set is not consumed.
See SQLCloseCursor See Closing the Cursor
impl<'con, 'param> Statement<'con, 'param, NoCursor, Unprepared>
[src]
fn with_parent(parent: &'con Connection<Connected>) -> Return<Self>
Allocates a new Statement
fn prepare<T: ?Sized>(
self,
statement_text: &T
) -> Return<Statement<'con, 'param, NoCursor, Prepared>, Statement<'con, 'param, NoCursor>> where
T: SqlStr,
self,
statement_text: &T
) -> Return<Statement<'con, 'param, NoCursor, Prepared>, Statement<'con, 'param, NoCursor>> where
T: SqlStr,
Prepares a Statement
for execution by creating an Access Plan.
See SQLPrepare Function See Prepare and Execute a Statement (ODBC)
fn exec_direct<T: ?Sized>(
self,
statement_text: &T
) -> ReturnOption<Statement<'con, 'param, Opened>, Statement<'con, 'param, NoCursor>> where
T: SqlStr,
self,
statement_text: &T
) -> ReturnOption<Statement<'con, 'param, Opened>, Statement<'con, 'param, NoCursor>> where
T: SqlStr,
Executes a preparable statement, using the current values of the parametr marker variables.
- See SQLExecDirect
- See Direct Execution
impl<'con, 'param> Statement<'con, 'param, NoCursor, Prepared>
[src]
fn execute(
self
) -> ReturnOption<Statement<'con, 'param, Opened, Prepared>, Self>
self
) -> ReturnOption<Statement<'con, 'param, Opened, Prepared>, Self>
Executes a prepared statement, using the current values fo the parameter marker variables if any parameter markers exist in the statement.
impl<'con, 'param, A> Statement<'con, 'param, Positioned, A>
[src]
fn get_data<T: ?Sized>(
&mut self,
col_or_param_num: SQLUSMALLINT,
target: &mut T
) -> ReturnOption<Indicator> where
T: CDataType,
&mut self,
col_or_param_num: SQLUSMALLINT,
target: &mut T
) -> ReturnOption<Indicator> where
T: CDataType,
Retrieves data for a single column or output parameter.
See SQLGetData
Trait Implementations
impl<'con, 'param, C: Debug, A: Debug> Debug for Statement<'con, 'param, C, A>
[src]
impl<'con, 'param, C> Diagnostics for Statement<'con, 'param, C>
[src]
fn diagnostics(
&self,
rec_number: SQLSMALLINT,
message_text: &mut [SQLCHAR]
) -> ReturnOption<DiagResult>
&self,
rec_number: SQLSMALLINT,
message_text: &mut [SQLCHAR]
) -> ReturnOption<DiagResult>
Returns the current values of multiple fields of a diagnostic record that contains error, warning, and status information. Read more