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

Locate class

java.lang.Object
   +----borland.jbcl.dataset.Locate

About the Locate class

Variables  Properties  Methods  
The Locate class encapsulates the most commonly-used options when performing a search operation. It allows you to specify how a particular row is found when using the DataSet.locate() method and the DataSet.lookup() method. For example, options include case sensitivity, search for the first, subsequent or last occurance, and so on.

The Locate variables may be combined where it makes sense to do so. For example, you can search using partial strings and specifying case insensitivity. Combine variables using the Java OR operator of a vertical pipe symbol (|) between each variable.

For more information on using Locate variables in your application, see the Locating data topic in the Database Application Developer's Guide.


Locate variables

Variables implemented in this class

Locate properties

*Read-only properties **Write-only properties

Properties implemented in java.lang.Object

Locate methods

Methods implemented in java.lang.Object


Locate variables

CASE_INSENSITIVE

  public static final int CASE_INSENSITIVE = 0x8
Search ignoring upper or lower case differences. Valid only for String columns.

FAST

  public static final int FAST = 0x80
Use search values from the previous search (instead of initializing new values). This option offers quicker performance since new values are not initialized.

FIRST

  public static final int FIRST = 0x20
Locate the first occurance.

LAST

  public static final int LAST = 0x40
Locate the last occurance

NEXT

  public static final int NEXT = 0x2
Search from the current row position.

NEXT_FAST

  public static final int NEXT_FAST = NEXT|FAST
Search from the current row position, using values from the previous search.

PARTIAL

  public static final int PARTIAL = 0x1
Allow partial matches for Columns containing String values. The columns are specified in the locate method in the order that they are searched (and not in Column order of the DataSet). This option works only on the last column specified, and only for String columns.

PRIOR

  public static final int PRIOR = 0x4
Search backwards from the current position.

PRIOR_FAST

  public static final int PRIOR_FAST = PRIOR|FAST
Search backwards from the current position using values from the previous search.