Forms :: Display Map Using Mapviewer?
Sep 6, 2012How do I display map on the oracle forms using mapviewer?
View 1 RepliesHow do I display map on the oracle forms using mapviewer?
View 1 RepliesI'm new in the group and no have much experience in Spatial area.
I'm looking for information about the posibility of use google places apis to get point of interest from Oracle Spatial / MapBuilder / MapViewer in order to use point of interest from google with own spatial information.
is there a way to keep the display of the form when we call another new form. my scenario will be as following:
am in form1 , i call form 2 from a menu, after this call form2 is open in place of form1.
i have no control in form1 and i can't change anything on it, i don't know hw the menu option is calling form2.the only control i have will be within form2 if there is any change i can make it.i read something about MDI, and OPEN_FORM() procedure, but i think this will required a change in form1 which i can't do.
is there any change i can make in form2 to display it and keep the display of form1 at the same time behind it ?
I would like to display PDFs in Oracle Forms. The PDFs are stored in an Oracle 10g database.
View 2 Replies View RelatedI want to display a specified image if not form_success!
declare
image_path varchar2(80) := 'C:R_ORACLEPHOTOS';
photo_name varchar2(80);
begin
:system.message_level := '25';
[code].......
My form failed to display photo (data type long row).
scenario a)
If photo in black and white with
width : 472 pixels
height: 590 pixels
horizontal resolution : 300dpi
vertical resolution : 300dpi
bit depth : 8
size file : 28KB
scenario b)
If photo in color with
width : 124 pixels
height: 155 pixels
horizontal resolution : 75dpi
vertical resolution : 75dpi
bit depth : 24
size file : 14KB
Above 2 scenario:
My form 6 program can successful display the photo for scenario a , while for scenario b, my form 6 program failed to display the photo.
I have a form in which the fields are not database items i want to display the next record, i know i can use the next_record for the same but it does not work since it is not the database item, is there any way when the item is not the database item and i can see the next record. I use the cursor for loop but since it fecthes all the records in one go it cannot display one record at the time in the form..
View 3 Replies View Related I want to create dynamic Lov. How can I create it? For practice I create a LOV at design time
RECORD_GROUP_QUERY value:
SELECT * FROM
EMP.
THEN I write some code in WHEN-BUTTON-PRESSED Trigger to replace RECORD_GROUP_QUERY at run time. Code is:
........
v_rg_id:=CREATE_GROUP_FROM_QUERY('TEST','SELECT * FROM DEPT');
........
After this I found a error at run time which is FRM-41826: Cannot replace group; columns don't match LOV.
In alters I want to display a value dynamically.
like when deptno=10 came then it should dynamically displays the message like Department 10''.
when deptno=20 came then it should dynamically displays the message like Department 20''. and.....
i have master-detail form.in master my bill_id gets generated when new form is open and i copy the same bill_id in detail(tabular)for each item.all the items which i enter in detail form get save the same bill_id which got generated.
in another form(which is tabular) i want to display bill_id's from detail form.but in detail form . There are same bill_id's more than once.but i want to display those bill_id's which are more than once only once.
In my form i have 2 datablocks, the first contains only a display item which is populated from a lov when a user presses a button. The second datablock shows a list of items which should be queried dependant on the value of the above LOV. What i thought i could do is on a post-change trigger for the display item is:
go_block('block_name');
do_key('execute_query');
However, i am told i cannot do these in a post-change trigger, how to acheive what I am looking. Would i perhaps have to create my own trigger somehow or is their a simplier way.
I have problem about displaying current records with same table(tbl_pawnitem). I have 2 transactions which are the pawned transaction and for sale transaction. and both transactions save into tbl_pawnitem table..i want to display only in my list the for sale transaction without deleting the records of pawned transaction. what condition i will use?
View 5 Replies View Relatedi want to display employees details when i am passing Deptno and that department employees only display in Oracle Forms
View 16 Replies View Relatedhow to display an image(blob) on a form . i have tried all i could but still failed to display it on the form.Yes i searched the forum without any break through. below is the code i used to create data block and upload photos (JPG). the only problem am facing is retrieving them from forms. am using form 6i 10g database.
grant connect, resource, imp_full_database, exp_full_database to en;
grant create any directory to EN;
grant create any library to EN;
GRANT EXECUTE ON CTX_DDL en;
CONN en/en@pacific
Connected
[code]...
I am using forms 6i and oracle 10g. i want to display a char from database. that means a database string 'Bangladesh' is display from by one char to one char.
and display view right to left first display "B" then "BA" then 'BAN' etc.
I have problem follow: i create a forms 10g and run it then errors. Now, i want to display code errors,how do i do?
View 2 Replies View RelatedThere is a table, desc :-
name varchar2(10), class number(1)
values:-
name class
----- ------
qwe 1
asd
zxc 2
Here 'asd's class is NULL.
Now, using forms, how do i display the above with the modification where NULL will be shown as -1?
that is-
name class
----- ------
qwe 1
asd -1
zxc 2
I have a list box that is populated from a record group using a WHEN-NEW-FORM trigger. When I run the form this displays fine when the list box is set as Poplist or Tlist, but when I change this to combo box and run the form it doesn't load properly in the browser (a blank screen followed by the background a a toolbar that says window).
View 3 Replies View Relatedi want to display all the records of my database in a table with scrollingexample if i have 3records in my DB so a table must have 3records too !!!this is my code :
DECLARE
Cursor cur IS
SELECT numb_ph AS phone,
name_emp AS name
[code]...
but the problem 's all records of my DB are display in one record (to view another record i use the scrolling ..
i want something like auto-text in forms 6i in list box if user is enter M then words related to M , Middle east, Michael, Mexico should appear and user will have the option to select from this three options , if he presses m and then e only mexico should appear.How i can achieve this.
View 4 Replies View RelatedI just want to know if is it possible to display PDF blob file within the forms. Currently I use webutil to open pdf in browser. This time I need to display it in forms, so that upon scrolling, the user can view the pdf images of that particular record.
View 1 Replies View RelatedI want to display the current database username in a text field after logging in at run time,i.e after logging in the username should should display in a text field.e,g. if i login as scott then 'scott' should display in the text box.
View 3 Replies View Relatedwhen i open my oracle form on my live application server to display sysdate its does not show me.but when i open this same form on my test application server its shows my current sysdate time.
View 1 Replies View Related how can i get a text box value from a form and display it in another form?
let say i have a text box named x in form1 and text box y in form2 and i need to display automatically the value of x in y
I need to display my alert prompt right after I detect the discrepancy on amount. I place my code on POST-BLOCK. The problem is, after the query, the alert pops out right before the new canvas where the block with POST-BLOCK trigger shows.
I need to display first the canvas before the alert but seems like the process of displaying canvas is the last job oracle does. So even if I place my code on post-record or any other trigger it will be the same.
I have created two tabs tab1 & tab2. after changed(not while changing/before changing)) into tab2 all records should be display.
I have written execute_query in when-tab-page-changed.but that is before/while changing.i want after entered in tab2 it should be display.
am facing a Problem in creating display items .First I create a display item and name it ITEM6This Display item will show Department name of employees .I create a Block Level Trigger to invoke this display item .
WHEN-VALIDATE-ITEM
select dname into :ITEM6 FROM DEPT where :EMP.DEPTNO=DEPT.DEPTNO;
In Property Palette I edit following
Data Type : char
canvas :canvas4
Then I save ,compile and Run it successfully .But when i press Execute Query button . It shows me Following error message .
SELECT ROWID,ITEM6,EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO FROM scott.emp
ORA-00904: "ITEM6": invalid identifier
displaying Hindi fonts in Oracle forms 11g.
View 2 Replies View RelatedHow to invoke and display a scanned image side by side with an Oracle Form without minimizing one of the two. I used the code below to call my document, but when i navigate to it so as to be able to see the detail , the oracle form will be dismissed and vice-versa.
DECLARE
v_claim varchar2(400):=:global.photo_path||:b4.doc_no||'.JPG';
BEGIN
client_Host('cmd /c START "" "'||v_claim||'"');
[code]....
Should there be another better way,
i want to make a form from creating new user and password but i don't know how to display password in *** style and how to save it with s-key character.
View 1 Replies View Related