Forms :: Customize Position Of ALERT Message On Screen As Per Requirement
Mar 19, 2010I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.
View 4 RepliesI am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.
View 4 RepliesI would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i
PROCEDURE CenterWindow (win_name VARCHAR2) IS
w_mdi NUMBER;
h_mdi NUMBER;
w_win NUMBER;
h_win NUMBER;
[code]...
How can i set alert message for users tablespace.
for ex
My users(tablespace) data file size is 100m . If 90m reached , i need some alert message through email or mobile.
Os : linux 4
version :10.2.0
I see following warning message in alert log file.
Quote:WARNING: OMF is enabled on this database. Creating a physical standby controlfile, when OMF is enabled on the primary database, requires manual RMAN intervention to resolve OMF datafile pathnames.
NOTE: Please refer to the RMAN documentation for procedures describing how to manually resolve OMF datafile pathnames.
Is it just an information or something like warning message we need to look into it.
I have leave application form based on the LEAVE table, it has the following columns,
leave_id(primary key)
emp_name
from_date
to_date
no_of_days
Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?
In linux server for 11g oracle. how do I keep date time line for each error message?example as
cat alert_test.log | grep 'ORA'
grep 'ORA' alert_test.log
I like output as
Mon Aug 20 01:54:29 2012
ORA-01560 caused by SQL...........
I know we can use diag... But I want to some linux command for my debug.
how can i create and customize a sign in popup when running an oracle form?
View 1 Replies View Relatedhow to customize the font color of only selected nodes in a hierarchical tree.
View 5 Replies View RelatedI have a form with fields like, UserName, User ID Email Address. This is used to create new users & edit existing user information. I wanted to make the Email field mandatory. So i made the email field as 'Required' via Proerty Pallette. So when ever i create new users after this change, i get a message saying 'Field must be required' when i try to skip this email field.
However when i edit existing user information and try to save the data with no email address i am able to save. So, where when i try to save a user info with no email address, i should get a warning saying 'email address is required'. How to go about it and if i wil have to create any trigger.
I have a requirement to develop a form from scratch level.The form contain search criteria and a search button.On pressing the search button it will display the search result just below the search criteria.The search result contain two button, EDIT and DELETE button in each row.
View 3 Replies View RelatedI have included a calender control in my form and its working fine.Now, my problem is how can I automatically place the calender next to the text-item (for example, "block.invdate")if the push button is pressed to call a calender.
View 1 Replies View RelatedSQLserver in stop condition when i play it. it again stop
View 1 Replies View RelatedI want to get current mouse cursor position dynamically,what should i do.
View 3 Replies View RelatedI am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?
Yes No Cancel.
Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.
I need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies View Relatedwhat name is used to reverence the mouse cursor in Forms. I am trying to state that if the user reaches the last record in a file and clicks the mouse on the empty record below that they will get a message saying they are at the last record (basically so it means they have to manually click an add record button before they can add a new record)
I currently have this:
IF :SYSTEM.LAST_RECORD = 'TRUE'
THEN
<something here> := :SYSTEM.LAST_RECORD;
MESSAGE('You are at the last record.');
ELSE
DOWN;
END IF;
Where i have <something here> is where i assume the refence for the mouse cursor should go, of which i dont know the name, am i correct?
Another thing is that I have a checkbox that is originally NO but when set to YES cannot be turned back to NO.
I have accomplished this by putting the following code in the WHEN_CHECKBOX_CHANGED trigger and it works fine. However it also updates the checkbox to NO and then back to YES, , as a result this brings up my Are you sure you want to update message. I originally thought that if i took out the :in_active := 'Y'; the FORM_TRIGGER_FAILURE would stop the checkbox being changed in the first place but this didnt appear to be the case. how to accomplish this without letting it update at all (perhaps put something in the WHEN_VALIDATE trigger?
DECLARE
return_alert number;
BEGIN
if :in_active = 'N' THEN
return_alert := SHOW_ALERT('checkbox_alert');
:in_active := 'Y';
RAISE FORM_TRIGGER_FAILURE;
END if;
END;
i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example
if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd
i want to bypass the logon screen in forms 6i i have trigger but it not works.
View 1 Replies View RelatedI am developing menu.. in that menu having 5 different forms.. these forms are 3 one schema ( i.e X ) and remaining 2 forms are one schema ( i.e Y )..
i am calling x schema
form level trigger on_logoon :
onlogon('a','a@X');
a for Username and x database name and another form in form level trigger on_logon : coding
logout;
logon('b','b@Y');
b for Username and y database name
but the form is not executing and not saving the record's.
I have an form with a few canvases already in it. The problem is that I want to see a particular canvas which shows the toolbar at the top of the window but it dosent show up on the form. I checked the property palette and the canvas is visible. There is also an other canvas right at the top of the form. How do I move the other canvas down if this is covering the toolbar canvas. How do i move the canvas down as it dosent show any X position in its property palette.
View 1 Replies View Relatedhow the forms webpage/forms screen can be center oriented which is by default top left oriented in the content webpage.
View 1 Replies View Relatedi am not able to get whole form on the screen. some part of the part is missing and even there is no scroll bar to slide the form. I have also change the form applet parameter..my screen size is 1024 x 768 and this is same as of the size of form applet.
View 1 Replies View RelatedI migrate some forms&reports 6i to 11g, i have some issues on screens. they are
1.In some of the migrated screens the prompts are not properly aligned. In some cases the Prompts which were in bold are converted to regular fonts.
2.The font size have increased, due to this the data are not completely visible in the fields. Do we have any provision for reducing the font size so that this gets applied for all the screens instead of changing the font size in each screen?
3. In case of Push buttons the names of the buttons are not fully visible.
4.The reports are not getting generated if we access the Application using Google chrome.
I'm trying to bypass the login screen for my apps by creating a .cfg file (ani.cfg) from the formsweb.cfg with two inclusions:
1.userid=<login_name>/<password>@database_connect
2. form=<my_form>.fmx (instead of default test.fmx)
Now while running the through /forms/frmservlet?config=ani
'm getting two things:
1.error message sometimes with a java file details list (attached)
2. it's openning the Java Security Warning window where on clicking 'Run' nothing happens.
We access the 10g forms and reports application through citrix and non citrix environments, when we are trying to print the screen from citrix environment the screens are getting shaded but if we print through non citrix environment screens are printing fine.
View 2 Replies View RelatedHow can I replace an existing image with a new one on my splash screen. Here's what I mean by this:
I have a form which already has a splash screen logo. This logo will be replaced with a new one. The existing logo is attached as an image in the form of a .tiff file. There are no triggers on the form excepting a "when new form instance" which just says "SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,TITLE,'ABC').
How can I ensure that the old logo is replaced with a new one. Here's what I did to replace, i.e my trouble shooting steps:
a)opened the form and deleted the existing splash screen/.tif file
b)went into the layout editor and clicked on "EDIT-> IMPORT" and mapped it to the .tif file that's persent in the local directory. As soon as I click OK, I get the following message :
FORMS-VGS-507- Cannot open file or file not in specified format.
BTW- another trouble shooting step was that I discarded the original and the one to be replaced .tif file. After this I imported another .tif file , so as to eliminate/narrow down the issue. The other .tif file when imported, attached itself perfectly fine, except that it was too large. (How to crop the size). I am new to Oracle forms10g and my area of work is pl/sql,sql,crystal reports and VB.
I am trying to select a row on the screen and delete a individual row from the screen after hitting the delete button. Whenever i select the row it gets highlighted and also the alert box comes up asking if the record needs to be deleted. When I say yes I notice that the row does not get deleted. The code behind the delete button is as follows
(P.S the block is based of a table and commit_form works and changes are saved to db but not delete_record)
begin
--
Set_Item_Property('my_block.emp_no_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.emp_LName_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.emp_FName_copy',current_record_attribute,'va_delete_record');
Set_Item_Property('my_block.last_worked_date_copy',current_record_attribute,'va_delete_record');
--
synchronize;
Set_Alert_Property(alert_id, ALERT_MESSAGE_TEXT, 'Do you want to delete the Highlighted record? {NOT YET}');
[Code]....
I have One .FMB Screen and in this Screen One Table , I Compile and attach in ERP System but when I tried to open thst screen is not open and also application is stucking.
View 1 Replies View RelatedWhen I try to run the form by clicking Program/Run form, it opens a webpage(explorer) and displays ?ORACLE FORMS? label, but does not show the form only blank screen appear. When I try to run the form by clicking Program/Run form, it opens a webpage(Firefox), but does not show the form only blank screen appear.
I have noticed that in Start OC4J Instance it has some thing like as below:
SYSDATE TIME FormsServlet init():
configFileName: E:DevSuiteHome_2/forms/server/formsweb.cfg
testMode: false
pop-ups is not blocked in my browser I have allow active content to run in files on your computer.directory name (where the form is stored) also doesn't contain any spaces.
Also I have change the
baseHTMLjinitiator=basejini.htm
to this
baseHTMLjinitiator=basejpi.htm.
I have done all the things mention in this forum to overcome this error.But, still the same problem is there.Also please take a note that I am using JRE not JINITIATOR. Beacuse when I am using the JINITIATOR it give me the problem of browser crash in both IE and firefox.Also I am using Windows XP and oracle form 10g.
I've already check on internet and the forum if there is a way to maximize a window on the secondary monitor instead of the main one. There is a parameter to make that? or Oracle forms maximize the windows only on the main screen?
View 1 Replies View Related