borland.jbcl Packages borland.jbcl Class Hierarchy borland.jbcl.dataset
java.lang.Object +----borland.jbcl.dataset.ReadRow +----borland.jbcl.dataset.ReadWriteRow +----borland.jbcl.dataset.ParameterRow
Variables Constructors Properties MethodsThe 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.
public static final int IN = 1
public static final int IN_OUT = 2
public static final int OUT = 4
public static final int RESULT = 3
public static final int RETURN = 5
public ParameterRow()Default constructor
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.
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.
public void addColumn(borland.jbcl.dataset.Column column, int parameterType)Adds a Column.
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.
public void addColumn(java.lang.String columnName, int dataType, int parameterType)Adds a Column with given dataType to a row.
public int getParameterType(int ordinal)
public int getParameterType(java.lang.String columnName)