nsmcp::DatabaseSession method scalar (public)

 <instance of nsmcp::DatabaseSession> scalar sql

Defined in /usr/local/ns/tcl/nsmcp/database.tcl

Execute a query and return its first value. Reuse execute in the caller's scope, retaining its current-variable binding behavior.

Parameters:

sql (required)

Trusted SQL text; current values are resolved in the caller's scope.

Returns:

The first column of the first row, or an empty result when no row is returned.

Testcases:

No testcase defined.

Source code:

set rows [uplevel 1 [list [nsf::current object] execute $sql]]
if {$rows eq ""} {
    return {}
}
return [lindex [lindex $rows 0] 1]

XQL Not present:

Generic, PostgreSQL, Oracle