odbc-prepare ( dbc string -- statement )

Vocabulary

odbc

Inputs

dbc	an ODBC database connection handle
string	a string containing SQL

Outputs

statement

an ODBC statement handle

Word description

Prepares (precompiles) the given SQL string, ready for execution with odbc-execute. When finished with the statement odbc-free-statement must be called on it.

See also

odbc-init, odbc-connect, odbc-disconnect, odbc-prepare, odbc-free-statement, odbc-execute, odbc-next-row, odbc-number-of-columns, odbc-describe-column, odbc-get-field, odbc-get-row-fields, odbc-get-all-rows, odbc-query

Definition

USING: alien.strings io.encodings.utf8 kernel sequences ;

IN: odbc

: odbc-prepare ( dbc string -- statement )
    [ alloc-stmt-handle dup ] dip utf8 string>alien dup length
    [ SQLPrepare ] keepdd check-statement ;