Home

Connection

ODBC database connection

Operations

New

Constructor

New(ds:String, username:String, password:String)
Parameters
NameTypeDescription
dsStringODBC data source
usernameStringODBC connection name
passwordStringODBC connection password

Close

Closes a connection

method : public : Close() ~ Nil

CreateParameterStatement

Create a parametrized SQL statement

method : public : CreateParameterStatement(sql:String) ~ ParameterStatement
Parameters
NameTypeDescription
sqlStringSQL statement

Return
TypeDescription
ParameterStatementresult set

IsOpen

Check rather a connect is open

method : public : IsOpen() ~ Bool
Return
TypeDescription
Booltrue if connected, false otherwise

Select

Executes a SQL select statement

method : public : Select(sql:String) ~ ResultSet
Parameters
NameTypeDescription
sqlStringSQL statement

Return
TypeDescription
ResultSetresult set

Update

Executes a SQL update statement

method : public : Update(sql:String) ~ Int
Parameters
NameTypeDescription
sqlStringSQL statement

Return
TypeDescription
Intresult code