Documentation for Auto Intellect 5.0. Documentation for other versions of Intellect is [available too].

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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 settings dialog window (Fig. 7.6—12, 1).
  2. Select the «External Plates Database» in the objects tree (Fig. 7.6—12, 2).


Fig. 7.6—12 Selecting the SQL-query set up

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


Fig. 7.6—13 SQL- query settings

  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%.

Note 1. Detailed information concerning setting the SQL-queries is given in the corresponding reference manual.
Note 2. SQL-query, given for example(Fig. 7.6—13),returns the required columns (Table 7.6—3)from the external DB (Fig. 7.6—14) if the plate in this DB coincide with the identified number.
Table 7.6—3 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


Fig. 7.6—14 Example of SQL-query search method results

  1. To save the changes and close the « SQL-query settings» dialog window click «Ok «(Fig. 7.6—13).

Note. Click Cancel to close the dialog window « SQL-query settings» without saving the changes.

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

Setting up the SQL-query is completed.

  • No labels