Product: MapBasic
Version: 6.5
Platform: Not Platform Related
Category: Documentation
Summary:
Find Using statement - Description.
Question:
How is the Find Using statement used?
Answer:
Purpose
Dictates which table(s) and column(s) should be searched in subsequent Find operations.
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 Query>Find.
inset_value is a positive integer value representing how far from the ends of the line to adjust the placement of an address location. 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.
value is a positive integer value representing the number of meters to offset the placement of an address location back from the street. Valid values are from 0 to 32,767.
dist_unit is a string that represents the name of a distance unit (e.g. "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 the Refine clause is omitted, subsequent Find statements expect a simple location name (e.g. "Portland"). If a Refine clause is included, subsequent Find statements expect a location name and a region name (e.g. "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 saves the inset and offset settings specified the last time the user chose Query>Find Options, Table>Geocode or executed a Find Using statement. Therefore, the last specified inset/offset options become the default settings for the next time.
Example
Find Using city_1k(city)
Refine Using states(state)
Find "Albany", "NY"
See Also
Querying tables--> .
Last Modified:
|