Gemstone Data Library
Ado
Executes the SQL statement using Connection, and returns the value in the first column
of the first row in the result set as type returnType, substituting defaultValue
if Value is retrieved.
Definition
Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.147 -- Release Build+c5cc8ba56e7568e903c204fe8ae9773b97af8eef
Value in the first column of the first row in the result set.
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.147 -- Release Build+c5cc8ba56e7568e903c204fe8ae9773b97af8eef
C#
public Object? ExecuteScalar(
Type returnType,
Object? defaultValue,
string sqlFormat,
params Object?[] parameters
)VB
Public Function ExecuteScalar (
returnType As Type,
defaultValue As Object,
sqlFormat As String,
ParamArray parameters As Object()
) As ObjectC++
public:
Object^ ExecuteScalar(
Type^ returnType,
Object^ defaultValue,
String^ sqlFormat,
... array<Object^>^ parameters
)JavaScript
function ExecuteScalar(returnType, defaultValue, sqlFormat, ... parameters);Parameters
- returnType Type
- The type to which the result of the query should be converted.
- defaultValue Object
- The value to be substituted if Value is retrieved.
- sqlFormat String
- Format string for the SQL statement to be executed.
- parameters Object
- The parameter values to be used to fill in DbParameter parameters.
Return Value
ObjectValue in the first column of the first row in the result set.