odbc vocabulary
Factor handbook > Vocabulary index


Summary
ODBC (Open DataBase Connectivity) binding

Meta-data
Tags:database
Authors:Chris Double, Alexander Ilin


Words

Tuple classes
ClassSuperclassSlots
column tuplenullable digits size type name number
field tuplevalue column


Symbol words
SQL-BIGINT
SQL-BINARY
SQL-BIT
SQL-CHAR
SQL-DECIMAL
SQL-DOUBLE
SQL-FLOAT
SQL-GUID
SQL-INTEGER
SQL-INTERVAL-DAY
SQL-INTERVAL-DAY-TO-HOUR
SQL-INTERVAL-DAY-TO-MINUTE
SQL-INTERVAL-DAY-TO-SECOND
SQL-INTERVAL-HOUR
SQL-INTERVAL-HOUR-TO-MINUTE
SQL-INTERVAL-HOUR-TO-SECOND
SQL-INTERVAL-MINUTE
SQL-INTERVAL-MINUTE-TO-SECOND
SQL-INTERVAL-MONTH
SQL-INTERVAL-SECOND
SQL-INTERVAL-YEAR
SQL-INTERVAL-YEAR-TO-MONTH
SQL-LONGVARBINARY
SQL-LONGVARCHAR
SQL-NUMERIC
SQL-REAL
SQL-SMALLINT
SQL-TINYINT
SQL-TYPE-DATE
SQL-TYPE-TIME
SQL-TYPE-TIMESTAMP
SQL-TYPE-UNKNOWN
SQL-TYPE-UTCDATETIME
SQL-TYPE-UTCTIME
SQL-VARBINARY
SQL-VARCHAR
SQL-WCHAR
SQL-WCHARVAR
SQL-WLONGCHARVAR
SQLCHAR
SQLHANDLE
SQLHDBC
SQLHENV
SQLHSTMT
SQLHWND
SQLINTEGER
SQLPOINTER
SQLRETURN
SQLSMALLINT
SQLUINTEGER
SQLUSMALLINT


Ordinary words
WordStack effect
(odbc-get-all-rows)( statement -- )
<column>( nullable digits size type name number -- column )
<field>( value column -- field )
SQL-ATTR-ODBC-VERSION( -- value )
SQL-C-DEFAULT( -- value )
SQL-DRIVER-NOPROMPT( -- value )
SQL-DRIVER-PROMPT( -- value )
SQL-HANDLE-DBC( -- value )
SQL-HANDLE-DESC( -- value )
SQL-HANDLE-ENV( -- value )
SQL-HANDLE-STMT( -- value )
SQL-NULL-HANDLE( -- value )
SQL-OV-ODBC2( -- number )
SQL-OV-ODBC3( -- number )
SQLAllocHandle( handleType inputHandle outputHandlePtr -- SQLRETURN )
SQLDescribeCol( statementHandle columnNumber columnName bufferLength nameLengthPtr dataTypePtr columnSizePtr decimalDigitsPtr nullablePtr -- SQLRETURN )
SQLDisconnect( connectionHandle -- SQLRETURN )
SQLDriverConnect( connectionHandle windowHandle inConnectionString stringLength outConnectionString bufferLength stringLength2Ptr driverCompletion -- SQLRETURN )
SQLExecute( statementHandle -- SQLRETURN )
SQLFetch( statementHandle -- SQLRETURN )
SQLFreeHandle( handleType handle -- SQLRETURN )
SQLGetData( statementHandle columnNumber targetType targetValuePtr bufferLength strlen_or_indPtr -- SQLRETURN )
SQLGetDiagRec( HandleType Handle RecNumber SQLState NativeErrorPtr MessageText BufferLength TextLengthPtr -- SQLRETURN )
SQLNumResultCols( statementHandle columnCountPtr -- SQLRETURN )
SQLPrepare( statementHandle statementText length -- SQLRETURN )
SQLSetEnvAttr( environmentHandle attribute valuePtr stringLength -- SQLRETURN )
SQL_ERROR( -- value )
SQL_INVALID_HANDLE( -- value )
SQL_NO_DATA( -- value )
SQL_NO_DATA_FOUND( -- value )
SQL_SUCCESS( -- value )
SQL_SUCCESS_WITH_INFO( -- value )
alloc-dbc-handle( env -- handle )
alloc-env-handle( -- handle )
alloc-handle( type parent -- handle )
alloc-stmt-handle( dbc -- handle )
convert-sql-type( number -- symbol )
dereference-type-pointer( byte-array column -- object )
odbc-connect( env dsn -- dbc )
odbc-describe-column( statement columnNumber -- column )
odbc-disconnect( dbc -- )
odbc-execute( statement -- )
odbc-free-statement( statement -- )
odbc-get-all-rows( statement -- seq )
odbc-get-field( statement column! -- field )
odbc-get-row-fields( statement -- seq )
odbc-init( -- env )
odbc-next-row( statement -- bool )
odbc-number-of-columns( statement -- number )
odbc-prepare( dbc string -- statement )
odbc-query( string dsn -- result )
succeeded?( n -- bool )
temp-string( length -- byte-array length )


Class predicate words
WordStack effect
column?( object -- ? )
field?( object -- ? )


Files


Children
VocabularySummary
odbc.privateodbc.private vocabulary