Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

SqlSpBase

SqlSpBase is the base class for SqlStoredProc, SqlUdf, and SqlTrigger classes.

This class must not be used by itself.

Constructor

SqlSpBase()

Public Methods

Object GetParameterValue(String name)

Return the value of the parameter with the specified name.


Object GetParameterValue(int index)

Return the value of the parameter at the specified index.


SqlSpCommand NewSqlSpCommand()

Return a new object implementing the SqlSpCommand interface to be used to execute SQL commands.


void SetParameterValue(String name, Object value)

Set the value of the parameter with the specified name.


void SetParameterValue(int index, Object value)

Set the value of the parameter at the specified index.


void Err(String message)

Write a character-string message to the SQL log file, sql_server.log. You may include values of variables or return values of methods in the string using the standard concatenation operator (+).


void Log(String message)

Write a character-string message to the SQL log file, sql_server.log. Log includes internal details intended for development use and should be disabled in production. You can include the values of variables or return values of methods in the string using the standard concatenation operator (+).

TOCIndex