Also in Paradox there is an operator ONLY who does not belong to statistical as does not make any calculations, however, for the rest acts similarly: it unites in the groups of record containing one certain value.
The operator AND carries out type of actions "logical And" and is used when, for example, the user wants to receive records which at the same time meet all entered conditions in inquiry. The operator AND often serves one of the main components at a task of range of values.
If values arguments of the operator OR belong to one field, they should be entered into this field, dividing their key - 61 words OR. If they belong to different fields, they should be entered on different lines of an example of inquiry.
The operator NOT is for this purpose used. It is put before those values which emergence the user wants to avoid. This operator can is put before exact values, ranges, templates and other operators.
Data in a graphic field can be any pictures or schedules which are scanned or created in the column chesky editors. Paradox provides two ways of input of a graphic representation in the field:
By pressing in the Data Model window of the OK, Paradox button will open the Design Link dialog box which represents means of viewing and a choice of one of types of the initial drawing of the document. In a viewing window fields of model of data are represented.
The means intended for development of documents are used in the Form Design and Report Design windows. In both windows process of creation of the document consists of the same operations: a choice of objects, inspection, use of the tools located on SpeedBar, and a wide range of available methods of registration of the drawing of the document.
The element example is applied in inquiry to representation of some concrete value. In simple inquiries it is possible to apply an element examples in combination with reserved words and arithmetic operators to make certain calculations over values of fields. In multitabular inquiries an element examples are used for binding of tables on the general fields.
- To place graphics. Having clicked a mouse Graphic icon, it is possible to import graphics from Windows Clipboard and files of formats. BMP. PCX. TIF and others. Thus the inserted images can be scaled with various coefficients of scale.
In essence, inspection is a determination of properties of objects. Each object has the menu which options define its appearance (and, sometimes, behavior. This menu is caused at inspection. For example, at a field choice as object, its menu, along with others, contains the following options: a name, color, a frame, a font, a form, etc. Besides, some properties of objects are set by teams of the Ob71 jectPAL language. Further, if some objects for inspection were chosen at the same time, the made changes in properties of one of them, will similarly change also properties of others.
- To place in the document the elementary graphic objects - lines, rectangles, ellipses. For this purpose it is necessary to click a mouse the tool, to press the left key of a mouse and to move a mouse on the screen before giving to object of a necessary form and the sizes. Except straight lines, the user, working in Paradox, can draw also curves.
The palette does not call property, and shows it therefore in the form of palettes, usually, visual properties of objects are represented (color, shading, etc.). The palette in Paradox can be as disposable (after a choice in it any property it disappears), and "floating", fixed on the screen to which the user will have opportunity to address as required.
Blocking of records - very important and necessary operation for preservation of integrity of a database in the multiuser environment. If the user during the work in the environment (local or global) blocked record, others the user can look through it, however cannot edit or remove. Paradox automatically blocks record when the specific user starts it editing, and removes blocking when it leaves it.
* search of the alphanumeric values containing tipografichesky typographical errors or allowing various writing. In these cases the operator LIKE who is put before value which needs to be found is used.
Forms in Paradox are used for display of data from tables in the most various formats and in combination with graphic objects. Forms are developed, generally for use on the screen and, first of all, for simplification of process of data input.