PLSQL Diffusion Data Table on geographic carte

walidabdallah — Sun, 04 May 2014 21:26:42 GMT

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 two 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
.....
Bi --- 15 --- 1012
Bi --- 19 --- 1016
Bi --- 20 --- 1023
......

How can I disseminate or diffuse these data on the two polygons (Sd, Bi)that delimit the sud and Beirut regions as mentioned above according to their specific identification. ??

I thank and appreciate whoever gives me any suggestion.

software : Forms [32 Bit] Version 9.0.2.9.0 , oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), window , IE 8

topic PLSQL Diffusion Data Table on geographic carte in Python Questions

PLSQL Diffusion Data Table on geographic carte