v2025.6.2
All Bundles

Connection

ODBC database connection

Operations

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

New

Constructor

New(ds:String, username:String, password:String)

Parameters

NameTypeDescription
dsStringODBC data source
usernameStringODBC connection name
passwordStringODBC connection password

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