Diffusion Data Table on geographic carte

Marmarino

Member

I create a new form called MAP.FMB

At form Level: i create a trigger when_new_form_ instance :
Set_Custom_Property('BL.BEAN',1, 'SETIMAGE','file:///C:\Dev9i\forms90\My_Projects\Meteo\Location_map_Lebanon.jpg' ) ; -- this map has tow region Sud (Sd) and Beirut (Bi)

This form has a block : BL with

Bean Item (Bean)
has the following property (Item Type : BEAN, Implementation Class : oracle.forms.fd.MapComponent)
Under which I write the following trigger: when_custom_item_event: message( Get_Custom_Property('BL.BEAN',1, 'NAME'), no_acknowledge);

Button Item (BT)
has the following property (Item Type : Push Button)
Under which I write the following trigger : When button pressed:
Set_Custom_Property('BL.BEAN',1, 'SETFONTCOLOR','255,0,100' );
Set_Custom_Property('BL.BEAN',1, 'SETPOLYGON','Sd,url1,284,128,272,138,292,181,315,196,336,194,353,178,361,166,342,133');
Set_Custom_Property('BL.BEAN',1, 'SETPOLYGON','bi ,url2,274,146,246,163,221,230,213,258,260,304,307,304,341,281,341,204,336,192,316,198');

At run time when I press on the button BT the two polygons that determine the boundaries of the two regions (Sd, Bi) are well displayed.

In addition the two regions (Sud, Beirut) were related by their specific identification (SD,Bi)on relational database table for example as follows:

Table: Clim Data

Region_id --- temperature --- pressure
SD --- 20 --- 1012
SD --- 25 --- 1014
SD --- 30 --- 1018
SD --- 33 --- 1020
SD --- 35 --- 1025
 
Back
Top