borland.jbcl Packages  borland.jbcl Class Hierarchy  borland.jbcl.dataset 

ParameterRow component

java.lang.Object
   +----borland.jbcl.dataset.ReadRow
           +----borland.jbcl.dataset.ReadWriteRow
                   +----borland.jbcl.dataset.ParameterRow

About the ParameterRow component

Variables  Constructors  Properties  Methods  
The ParameterRow component is useful when working with parameter values for QueryDataSet and ProcedureDataSet components. Although scoped DataRows can be used for parameter settings, the Column components in the DataRow map directly to the columnd and therefore do not allow more than once reference in a DataRow. For example, you may want to specify query parameters which involve two or more range comparisons against the same Column. The ParameterRow component allows this by adding another layer of mappings: the values to the parameters (to the columns).

If your query is similar to

SELECT * FROM employee WHERE emp_no>=:LOW AND emp_no<=:HIGH
your ParameterRow should have a Column for each of its parameter names, :LOW and :HIGH. Place values you want the query to use in the ParameterRow and associate them with the query by their ParameterRow column names.

For more information on using parameterized queries in your application, see Using parameterized queries to obtain data from your database in the Database Application Developer's Guide.


ParameterRow variables

Variables implemented in this class

Variables implemented in borland.jbcl.dataset.ReadRow

ParameterRow constructors

ParameterRow properties

*Read-only properties **Write-only properties

Properties implemented in this class

Properties implemented in borland.jbcl.dataset.ReadRow

Properties implemented in borland.jbcl.dataset.ReadWriteRow

Properties implemented in java.lang.Object

ParameterRow methods

Methods implemented in this class

Methods implemented in borland.jbcl.dataset.ReadRow

Methods implemented in borland.jbcl.dataset.ReadWriteRow

Methods implemented in java.lang.Object


ParameterRow variables

IN

  public static final int IN = 1

IN_OUT

  public static final int IN_OUT = 2

OUT

  public static final int OUT = 4

RESULT

  public static final int RESULT = 3

RETURN

  public static final int RETURN = 5

ParameterRow constructors

ParameterRow()

  public ParameterRow()
Default constructor

ParameterRow properties

columns

 public Column[] getColumns()
 public void setColumns(borland.jbcl.dataset.Column[] columns)
Stores the Column components as a String array of Column names. Used by the JBuilder design tools.

ParameterRow methods

addColumn(borland.jbcl.dataset.Column)

  public void addColumn(borland.jbcl.dataset.Column column)
Adds a Column. This is used for parameterized queries and is a short-cut to calling addColumn(Column, int) by defaulting the parameterType to TypeIn.

addColumn(borland.jbcl.dataset.Column, int)

  public void addColumn(borland.jbcl.dataset.Column column, int parameterType)
Adds a Column.

addColumn(java.lang.String, int)

  public void addColumn(java.lang.String columnName, int dataType)
Adds a Column with the given dataType to a row. This is used for parameterized queries and is a short-cut to calling addColumn(String , int) by defaulting parameterType to TypeIn.

addColumn(java.lang.String, int, int)

  public void addColumn(java.lang.String columnName, int dataType, int parameterType)
Adds a Column with given dataType to a row.

getParameterType(int)

  public int getParameterType(int ordinal)

getParameterType(java.lang.String)

  public int getParameterType(java.lang.String columnName)