Page History

RegisterExact match

The same sequence of characters in the column with vehicle plates must correspond to a sequence of characters, corresponding to the identified vehicle plate.In the window

The Vehicle Tracer

window displays all table columns containing the vehicle numbers

Partial search

At least one sequence of characters, that is partially or in full present in the plate in the external BD must correspond to identified vehicle plate.

Wildcard search

At least one of the plates, stored at external DB, must correspond to identified vehicle plate. Wildcards are recorded to the external BD preliminary together with vehicle plates. Wildcards in the DB are recorded according to Transact-SQL rules. Wildcards may contain usual characters and wildcards (
Table 7.6—2) in wildcards in the required combination.

SQL-query

SQL-query is designed for extracting the required data from the table, containing plate's numbers and also from bound tables. SQL-query is used for more flexible setting up the Auto-Intellect PC (example of such see Setting up SQL-query is given in 7.6.6 part of the manual, Fig. 7.6—13)for plates search in the external database).

The Vehicle Tracer window displays the In the window Vehicle Tracer there are displayed table's columns of the external DB, stated database tables specified in the SQL -queryquery

The recognized number must correspond to at least one sequence of characters that is partially or completely contained in the number in the external plate database. You can select the maximum number of errors (mismatches of characters) in the number.

Note. The more errors are accepted, the more the search system is loaded.

%

Any string containing 0 and above characters in lengthwith a length of zero or more characters

Plates, containing elements 'аA', '385' and '78', divided by any number of characters, for example 'АОAO38578', 'а385мкA385MK78' correspond to the wildcard 'а%385%78A%385%78'

_ (underlining)

Any single character

Plates, containing a sequence of 4 characters , the first of which is '2' and the last is '5' correspond to the wildcard '2__5', for example 'АA256577', '2115ОК43OK43'

[]

Any single character , containing contained in a range ([аA-еE]) in the range or set ([абвгдеABCDE]) in the set

Plates, containing a sequence of 4 characters correspond to the wildcard '[еE-мM][2-5]53' . The sequence ends in '53',the first character belongs to the range еE-мM, the second one belongs to the range 2-5, for example 'к453мн02K453MH02', 'м253вт63m253BT63'

[^]

Any single character , that is not contained in the a range ([^а^A-еE]) or in the set ([^абвгде^ABCDE])

Plates, containing a sequence of 4 characters correspond to the wildcard '[^е^E-мM]499'. The sequence ends in '499', the first character does not belong to the range еE-мM, for example 'в499вк57B499BK57', 'н499H499578'