All Bundles
Connection
ODBC database connection
Operations
New
Constructor
New(ds:String, username:String, password:String)
Parameters
Name | Type | Description |
---|
ds | String | ODBC data source |
username | String | ODBC connection name |
password | String | ODBC connection password |
Close
Closes a connection
method : public : Close() ~ Nil
CreateParameterStatement
Create a parametrized SQL statement
method : public : CreateParameterStatement(sql:String) ~ ParameterStatement
Parameters
Name | Type | Description |
---|
sql | String | SQL statement |
Return
IsOpen
Check rather a connect is open
method : public : IsOpen() ~ Bool
Return
Type | Description |
---|
Bool | true if connected, false otherwise |
Select
Executes a SQL select statement
method : public : Select(sql:String) ~ ResultSet
Parameters
Name | Type | Description |
---|
sql | String | SQL statement |
Return
Update
Executes a SQL update statement
method : public : Update(sql:String) ~ Int
Parameters
Name | Type | Description |
---|
sql | String | SQL statement |
Return
Type | Description |
---|
Int | result code |