Setting up SQL-query for plates search in the external database

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 Plates search method selection in the external plates database).

To set the SQL-query do the following:

Go to the External Plates DB object settings panel.
Select the SQL query value from the Search method list (1).
Click the Edit SQL-query button (2).
The SQL-query configuration dialog window will be displayed in result.

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.

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

Note.

SQL-query, given for example, returns the required columns from the external DB if the plate in this DB coincide with the identified number.

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

To save the changes and close the SQL-query settings dialog window click OK.
Note.
Click Cancel to close the dialog window SQL-query settings without saving the changes.
Click Apply (3).

Setting up the SQL-query is completed.

Page tree

Documentation for Auto PSIM 1.0.1.