It provides to show the given coordinate on the map.
Map tool icon at Toolbox
How it looks like on the Canvas
Remarks
To show the location of the database on the map You can update the value of the map with an update value operation, after editing the Field Style field as SQL Query in the properties of the Map tool.
Properties
Properties of the form tool;
-
Name: The name of the tool will be written here.
-
Field Style: Select whether the information entered is fixed or SQL query.
-
Location: The coordinates of the location to be displayed are entered.
-
Zoom: The zoom level to the map is set.
-
Help Text: It is the text that is entered for comment when the mouse is placed on the tool.
-
Height / Width: Adjusts the height and width of the tool.
-
From Left / Top: Adjusts the distance of the tool from the left and top.
-
Values (Text*Value): The values to be displayed are entered.
-
SQL Query: SQL queries will be written here.
-
Fit Horizontal: Fits the tool to the full screen on the user’s screen.
-
Display: Makes the tool not appear on the screen.
Actions
-
When Clicked: Assign an “Action” as a click handler. For more information please click here.
Examples Used
In the example, the coordinates specified using the fixed-valued query will add a pin in the specified colors with hex, rgb codes, or names in the query. Below is the query text;
Select '40.714269,-74.005973','New York','#ff0000'
union all
Select '37.775196,-122.419205','San Francisco','rgb(76, 69, 183)'
union all
Select '34.052126,-118.243618','Los Angeles','Green'
You can add the following operation to the map tool to print the coordinates of the clicked pin in a text box.
The SQL Query field must be left blank in operation.
Event view with Update Value operation for the Map
The location area represents your location. The zoom area shows how it will be close to the client.
Client view on screen
In this example, when the form is opened, the pin in the specified color is shown above the cities of New York, San Francisco, Los Angeles. When the pin is highlighted, the text specified in the query is displayed as an area on the pin. When Pine is clicked, the coordinate of the pin clicked is displayed in the text box named Coordinate at the top right.
Since the coordinate, the area text, and color come from the square, it can be changed at any time.
For example, the amount of sales in the provinces is shown in the pin tip box. If the sales quantity exceeds the limit set for the province, the pin color for that province may be green, if it is determined, it may be yellow and if it is below the level, it may be red.