Odbc

class wellcad.com.Odbc(dispatch)

An ODBC object allows interaction with databases from within WellCAD.

Example

>>> odbc = borehole.odbc
>>> odbc.interpret_sql_statement('$dsn = OpenDatabase(Test, Admin)')
>>> odbc.interpret_sql_statement('$log = SELECT Depth, Value FROM tblGamma')

interpret_sql_statement(statement)

Executes the SQL statement provided

A user manual documenting the syntax of the SQL statements that can be used can be obtained by contacting support@alt.lu.

Parameters:

statement (str) – The SQL statement to execute.

Returns:

Whether the statement executed successfully.

Return type:

bool