The ADO Control Explained

Every WireCAD report contains one and only one ADO control . This control is responsible for retrieving data from the database. WireCAD can only assign this control to one of its databases at a time. If this control is deleted from the report layout it will not provide data, nor will it be able to fill in the Fields List Toolbar.

ADO Properties

This is an expanded view of the ADO control Properties window. Listed below are some of the key functions others are self-explanatory, explained in the description field when the property is highlighted, or non-essential to report creation.

ADO Control Descriptions

Item	Description
Custom	Presents another version of the property window.
ConnectionString	This is the type, and location of the WireCAD database that we are retrieving data from. Do not edit this.
Source	A SQL select statement used to determine which fields from which tables related to which other tables and in which order to display. Whew! That’s a mouthful. While it is beyond the scope of this manual to provide a lesson in SQL suffice it to say that the statement “Select * from [tblCables] ORDER BY [CableNo]“ will retrieve all records from the cables table and sort them by cable number. For more information view some of the existing reports.
Tag	Used within WireCAD to identify the data source. DO NOT EDIT THIS!
Name	Do not change this from DC1.

While it is possible to edit many of the fields and properties associated with the ADO control, if you do not know what you are doing and do not have an understanding of SQL do not change any of the defaults.