ComponentOne True DataControl® 8.0 is an ActiveX® control that replaces the VB data control with scores of added features to free you from the hours of coding formerly needed to build intuitive database front-end applications. You can finally stop repeatedly coding business logic, data validation, and error handling in each data-aware control. Just specify business logic, data relationships and constraints, and even UI and data presentation features as a set of rules at design time with absolutely no code - True DataControl will enforce them at run time!

Features

  • Ad-hoc Query Forms

    True DataControl simplifies the construction of query forms by completely eliminating manual coding and the need for an in-depth understanding of SQL.

  • Control Properties

    You can assign formulas to any properties of any controls on the form, even if they are not data-aware. True DataControl will automatically change the property each time the formula changes.

  • Field Modifications

    True DataControl can recognize changes to fields made by the end-user at the moment a change has been made, so you don’t have to write event procedures for all kinds of controls. No more click events in your code!

  • Master-detail Relationships

    True DataControl makes it very easy to specify one data source (detail) as dependent on another (master). Master-detail relationships are optimized for the best performance and natively combined with all other True DataControl features.

  • Filters

    True DataControl supports filter expressions restricting the contents of the data source.

  • Query Mode

    True DataControl brings you the Filter By Form functionality from Microsoft Access, greatly enhanced and much more flexible. You can now do Query By Example in Visual Basic, and without writing any code!

  • SQL with Parameters

    A limitation of all standard Visual Basic data sources prohibits the use of parameters in the underlying SQL statement at design time. True DataControl remedies this limitation and even allows expressions to be assigned to parameters, so they may be used without any manual coding.

  • Calculated Fields

    All you need to create a calculated field dependent on the values of other fields is to define a formula. True DataControl will maintain the field’s value and update it automatically.

  • Default Values

    You can specify the value to be assigned to a field in a new record, and even make it dependent on parameters.

  • One-to-one Links

    In addition to master-detail (one-to-many) relationships, a data source may be placed into one-to-one correspondence with another data source.

  • Data in Memory

    True DataControl can be used to manage data in memory arrays/variables in exactly the same way as it manages data of a database origin. Just define the fields at design time, and True DataControl will create internal memory storage. This powerful feature enhances all Microsoft and third-party data-aware controls, enabling them to be used in applications and forms that are not necessarily database-related.

  • Custom Data Sources

    As an alternative to database and memory array data sources, you can create customized data sources with event-driven code. This advanced feature is ideal for legacy data and proprietary file formats.

  • Field and Record Constraints

    Validation conditions, or constraints, can be imposed upon individual fields and/or upon the record as a whole. True DataControl will automatically test the constraints when the user changes a field or posts a modified record.