
Data Navigator contains a set of components for data searching and filtering different databases. The package can be used in VCL applications as well as in cross-platform CLX applications. The package includes a collection of non-visual components located on the Navigator Access bookmark and a collection of visual components located on the Navigator Controls bookmark. Non-visual components are designed for filtering or searching for data in different dataset components. Visual components are designed for data entry by an end-user, in this case non-visual components of this package will filter or search required data. You can use any search and filtration options of any level of difficulty in the required fields of a database table. It is also possible to set options for a strict or partial matching of the searched data with a value from a database table. It is possible to use the option when a searched for value is larger, larger or equal, less, less or equal to the value from a field of a database table. You can use the option when a searched for text begins, ends, or it is a part of the text of a database field and other element, with more than 15 different compare options. If you need to, you can easily add your own compare options. With the help of the logic operators “OR”, “AND” and brackets “(”, ” )” you can set necessary collaboration between different compare options. The search and filtration of necessary data is optimized with a current index, i.e. if a user inputs a set of data in some fields, a component first selects fields that match a current index (not necessarily all fields of the index) and makes a partial qualified search for a line. Then a full search for a required line, which matches every option, is carried out.
Continue Reading »