Purpose
Dictates which table(s) and column(s) should be searched in subsequent Find operations. You can issue this statement from the MapBasic window in MapInfo Pro.
Syntax
Find Using table ( column )
[ Refine Using table ( column ) ]
[ Options
[ Abbrs { On | Off } ]
[ ClosestAddr { On | Off } ]
[ OtherBdy { On | Off } ]
[ Symbol symbol_style ]
[ Inset inset_value { Percent | Distance Units dist_unit} ]
[ Offset value ] [ Distance Units dist_unit ] ]table is the name of an open table.
column is the name of a column in the table.
symbol_style is a Symbol variable or a function call that returns a Symbol value; this controls what type of symbol is drawn on the map if the user chooses Find command.
inset_value is a positive integer value representing how far from the ends of the line to adjust the placement of an address location.
value specifies the Offset value (the distance back from the street).
dist_unit is a string that represents the name of a distance unit (for example, "mi" for miles, "m" for meters.
Description
The Find Using statement specifies which table(s) and column(s) MapBasic will search when performing a Find statement. Note that the column specified must be indexed.
The optional Refine clause specifies a second table, which will act as an additional search criterion; the table must contain region objects. The specified column does not need to be indexed. If you omit the Refine clause, subsequent Find statements expect a simple location name (for example, "Portland"). If you include a Refine clause, subsequent Find statements expect a location name and a region name (for example, "Portland", "OR").
The optional Abbrs clause dictates whether MapBasic will try substituting abbreviations from the abbreviations file in order to find a match. By default, this option is enabled (On); to disable the option, specify the clause Abbrs Off.
The optional ClosestAddr clause dictates whether MapBasic will use the closest available address number in cases where the address number does not match. By default, this option is disabled (Off); to enable the option, specify the clause ClosestAddr On.
The optional OtherBdy clause dictates whether MapBasic will match to a record found in a refining region other than the refining region specified. By default, this option is disabled (Off); to enable the option, specify the clause OtherBdy On.
MapInfo Pro saves the Inset and Offset settings specified the last time the user executed a Find Using statement. Thus, the last specified inset/offset options becomes the default settings for the next time.
If Percent is specified, it represents the percentage of the length of the line where the address is to be placed. For Percent, valid values for inset_value are from 0 to 50. If Distance Units are specified, inset_value represents the distance from the ends of the line where the address is to be placed. For distance, valid values for inset_value are from 0 to 32,767. The inset takes the addresses that would normally fall at the end of the street and moves them away from the end going in the direction towards the center.
The Offset value sets the addresses back from the street instead of right on the street. value is a positive integer value representing how far to offset the placement of an address location back from the street. Valid values are from 0 to 32,767.
Example
Find Using city_1k(city)
Refine Using states(state)
Find "Albany", "NY" See Also:
Create Index statement, Find statement