Page History

There is a possibility to set SQL-query for extracting the required data from the table, containing plates and bound tables. The set SQL-query will be used while searching the plates in the external DB if the SQL-query search method is selected (see section Selecting the plates search method in the external DB).

To set the SQL-query do the following:

...

1. Go to Hardware tab of system System settings dialog window (Fig. 7.6—12, 1).
2. Select the «External External Plates Database» Database in the objects tree (Fig. 7.6—12, 2).
   

...

1. Image Added

...

1. Select the "SQL-query" value from the «Search method» Search method list (Fig. 7.6—12, 3).
2. Click the «Edit AQLEdit SQL-query» query button (Fig. 7.6—12, 4).
3. The «SQLSQL- query settings» settings dialog window will be displayed in result (Fig. 7.6—13).

...

1. 
   Image Added

1. Enter SQL-query to extract (SELECT) the required data from the table, containing plates and bound tables. To replace the identified plate use the variable %PLATE%.

   Info
   title Note

...

1. .

   Detailed information concerning setting the SQL-queries is given in the corresponding reference manual.

   Info
   title Note

...

1. .

   SQL-query, given for example

...

1. , returns the required columns

...

1. from the external DB

...

1. if the plate in this DB coincide with the identified number.

...

1.  
   Example of extracting the data from external DB

   Table	Table's column	Column's contain	Is returned in result of SQL-query
   NOMERS	GOS_ID	Primary keys of NOMERS' table recordings	No
   	GOS	Plates	Yes
   	DOC	Documents' keys, on the basis of which the plates have been recorded to the DB	Yes
   	DATE	Dates, of entering the plates to DB	No
   DOCS	DOC_ID	Primary keys of DOCS' table recordings	No
   	DOCUMENT	Document types, on the basis of which the plates have been recorded to the DB	Yes
   	PERSON	Persons, who entered the plates to the DB	Yes
   	GOS_ID	External keys of DOCS' table recordings, used for connection to the NOMERS table	No

...

1. Image Added

1. To save the changes and close the

   «

   SQL-query

   settings»

   settings dialog window click

   «Ok «(Fig. 7.6—13).

   OK.

   Info
   title Note.
   Click Cancel to close the dialog window

...

1. SQL-query

...

1. settings without saving the changes.

2. Click «Apply» (Fig. 7.6—12, Apply (5).

Setting up the SQL-query is completed.