Forms :: Stack Canvas Hides While Validation Of Any Item Is Failed On The Form?
Oct 18, 2011
i have a form based on tab canvas. for some values(on form) i am hiding some fileds or a complete frame on the form using stack canvas. it works fine but if a user enters a wrong value in some field i.e enters character in number field the stack canvas hides(showing the hidden fields).
I tried to use on error trigger at form level and when validate item trigger to show the canvas but it first hides the canvas once right value is entered it just shows canvas again. following is the code i wrote
IF MESSAGE_TYPE = 'FRM' AND MESSAGE_CODE IN ('40209','50016')
AND :SYSTEM.TRIGGER_ITEM IN (some field)
THEN
IF other_item_value = 'E' THEN
SHOW_VIEW('STK_CAN_ARL_INFO');
END IF;
I need not to hide the canvas in any case whether any other field on the form is validated or not.
View 4 Replies
ADVERTISEMENT
Feb 28, 2011
We have placed Stack canvas on tab canvas. The Stack canvas will be visible/Invisible based on some condition dynamically. The Issue is When you show the stack canvas by using Hide_View('Canvas') , the stack canvas is shown on all tab canvas instead of displaying in the first tab canvas.
How to over come this issue and can we place stack canvas on tab canvas?
View 1 Replies
View Related
Mar 30, 2010
I want to create a tabular type form on a tab canvas.. but my fields are often out of the form range. i want to create a stack canvas on tab canvas but it say that stack canvas and tab canvas must be created within content canvas.
how can i manage it what can i do now. i also attached pic of my tab canvas. i show some fields on tab canvas and 3 more fields i inserted on this canvas. And i can't reduced the width of my fields.
View 4 Replies
View Related
Oct 31, 2011
I have one column Value his Datatype is varchar2 and I want to validate it with Type column his values are(Char,Date,Number). If Column Type have value Number then column value should accept number input only. How we 'll achieve this.
View 3 Replies
View Related
Jan 24, 2011
I am modifying an existing form and wanted to do this with less number of modifications. The existing form has one checkbox item ( displayed and attached to database)..and its not in use ( was created for some enhancement that never implemented but code is there)..and in the form at several places its mentioned/calculated based on Updatabale/Enable/Queryable/Insert..all properties.
Since I want to use the same position of this check box so ..i simply detached the canvas from this item..it compiles fine but when login into application it gives al those errors like..FRM--item not update able.etc etc..
Is there any property to just hide an item inspite having related codes in the form ?
View 2 Replies
View Related
Dec 4, 2010
I just need to create a login form ..its like user will login using his given id and password will be encryted when entering and i just need to simple validation that if he has entered corrected password it will display message ok or else wrong password.
View 3 Replies
View Related
Feb 28, 2012
Is it possible to have a standard size for canvas or window of the form? like different users are having different screen resolutions and may have different screen sizes which cause forms not to come proper on the user screen. Is there some solution to avoid the user's resolution and should work on some standard measurements?
View 5 Replies
View Related
Feb 24, 2009
I'm facing a really strange problem in Forms with an FMB that has a couple of canvas, but the main one canvas is showing a JPG (like a Wall Paper for the application, in fact this FMB would be the main FMB and it will call the main menu also). The problem is on run-time (locally, running on windows, just in some Laptops). At execution time, there's a FRM-92102 error, but only deleting the image, and trying again, the Screen run perfect!
The worst part is that same FMB run perfect on other laptops. I've tried almost everything : Creating again, just the form with one canvas and importing the image, and Run, but same error appears again. Trying with another image, same results.
View 2 Replies
View Related
Mar 10, 2013
In my form i have a multi record block which is based on a table in which i am performing insertion, deletion, updation.
My requirement is as below,
While saving a records i want to check distinct value of specific item can not be greater than some value say 2. Then only my records should be saved. I am planning to populate those values in a collection table type and take the distinct values from it. How to populate record values in a collection table type.
View 2 Replies
View Related
Oct 30, 2010
I need to modify an existing form, thus I have to resize a canvas and a window for it. In windows, I run it and I got the right display. When I transfer it to dev server running in linux, then I compile and run it, it display the previous/unmodified size. I'm sure my form is the one that running, I placed some text there and it was displayed.
View 4 Replies
View Related
Jan 7, 2013
I created follwoing trigger successfully...
create or replace trigger BANKTRAN_BEF_DEL
before delete on BANKTRAN
declare
weekend_error EXCEPTION;
not_authentocated_user EXCEPTION;
begin
[code]...
but when deleting the records using query delete from BANKTRAN getting the below error
ORA-04098 trigger"BANKTRAN_BEF_DEL" is invalid and and failed re-validation
View 18 Replies
View Related
Feb 10, 2007
is there any method in placing a stacked canvas inside a tabbed canvas ?
View 8 Replies
View Related
May 11, 2011
I have Table that save a color (specific color) , i want to change this color for all forms included windows and canvases at Runtime (by Code) .
My problem is : i can't move from canvas to canvas to change its color ( name of canvas ) - no next canvas code - like next block?
View 1 Replies
View Related
May 25, 2011
Can we place tab canvas in content canvas?i have created one header section based on content canvas.next line level i need to display tab.how can i do this?
View 1 Replies
View Related
Apr 23, 2012
I have tried enough to put Tab canvas on content canvas so that they can appear in the same window. I have tried on internet and unluckily find only
[URL].....
I didn't understand how to do it.
View 2 Replies
View Related
Dec 12, 2012
i want to apply validation on date item. i have created some cases if any case would be fail then error shold be fire.How can i do this.
my code
DECLARE
F DATE;
T DATE;
BEGIN
SELECT TO_DATE(F_DATE),TO_DATE(T_DATE) INTO F,T FROM VENDOR_CONTRACT_MAS WHERE CONTRACT_ID=:P5_CONTRACT_ID
[code]...
View 2 Replies
View Related
Jan 20, 2013
I have a master-detail form, before filling up all the item in master cursor should not go to details, if user clicks in detail he should get a message.
When I am pressing ENTER to navigate from one item to another is asking'do u want to save the changes'.how to control this message and when pressedenter cursor should go to next item.
View 15 Replies
View Related
Aug 7, 2010
query also a button click the trigger used when button press event user then the write this query.
SELECT USER INTO :BLOCK3.DISPLAY_ITEM7 FROM DUAL;
View 7 Replies
View Related
Jun 11, 2004
I had used a When-Validate-Item trigger against an text item.
Also i had a push button (EXIT) for Exiting from the Form with code : Exit_Form(no_validation);
But if an invalid text is entered in the Text-Item and after that if i use the EXIT push Button then it doesnot exit from the Form till a valid text is entered inside the Text-Item.
how to Exit from Form even if the Text-Item has Invalid Value.
View 3 Replies
View Related
Feb 25, 2013
how can i get the chosen value in radio button into text item which is in another form?
Suppose i have 3 radio buttons (watch, gadget and jewelry)then I choose watch.How can i display that chosen radio button into the text item which is in another form?
View 7 Replies
View Related
Mar 29, 2011
I've a 2 stacked canvases(canvas_live_appmnt, canvas_cancelled_appmnt) and Tab canvas(cc_main).Now I need to move the stacked canvas on the Tab canvas.I tried writing the When-tab-changed trigger as follows: In the below code I was trying for only one of the stacked canvases.
DECLARE
L_LOCAL_TP_NAME VARCHAR2(30);
BEGIN
L_LOCAL_tp_name := GET_CANVAS_PROPERTY('CC_MAIN',topmost_tab_page);
IF L_LOCAL_tp_name = 'LIVE_APPOINTMENTS' then
SET_VIEW_PROPERTY('CANVAS_LIVE_APPMNT',VISIBLE, PROPERTY_TRUE);
--SET_VIEW_PROPERTY (FIND_VIEW ('CANVAS_LIVE_APPMNT'), DISPLAY_POSITION, 0 , 325);
ELSE
SET_VIEW_PROPERTY('CANVAS_LIVE_APPMNT',VISIBLE, PROPERTY_FALSE);
END IF;
END;
View 2 Replies
View Related
Mar 28, 2011
I am developing form, but there is issue when I Press F11 to query data.I make trigger form when-new-record-instance to assign values for item.But when i Press F11 then Block no clear.
View 1 Replies
View Related
Sep 8, 2011
i have a form having 4 database data blocks and one non database data block(for Push Buttons like SAVE,CLEAR,EXIT..).
In the control Block i have 5 push buttons out of which one is used to Save the entries and one to clear the form. In the coding of SAVE button after writing "COMMIT_FORM;" i want to disable all other Data block on my form excluding the one containing Push buttons so that the data entered by end user stay appearing on the form till he Clears the form.
Now the problem is that when i set enabled property of one particular text_item to false , the form if closing down along with the application, it is totally disappearing from screen.This is happening for one particular text item.
what could be the possible reason for this and what needs to be done to overcome this problem.
View 5 Replies
View Related
Oct 13, 2012
i have text item :P1_ADMISSION_DATE .i want to validate that item if user does not enter valid date forrmat then display me error.
Date Format is 'DD-MON-YYYY'
i have try with PL/SQL Expression in Validation
My validation code
:P1_ADMISSION_DATE=TO_CHAR(SYSDATE,'DD-MON-YYYY');How can i validate :P1_ADMISSION_DATE to enter valid date format by user.
View 2 Replies
View Related
Aug 30, 2012
I use apex 4.1..I have a tabular form a select like this
select
"STRATEGYID",
"STRATEGYID" STRATEGYID_DISPLAY,
"STRATEGYNAME",
"ISAVTIVE",
"STRATEGYSTARTYEAR",
"STRATEGYSTOPTYEAR",
"STRATEGYTYPEID"
from "#OWNER#"."STRATEGY"
where ISAVTIVE = 1STRATEGYSTARTYEAR and STRATEGYSTOPTYEAR as a Select List contain a value of year
I select from LOV like this
select y l, y v
from (select extract(year from sysdate) + rownum - 1y from dual connect by rownum <= 51)and
I have to Validate STRATEGYSTARTYEAR must Less than STRATEGYSTOPTYEAR
View 4 Replies
View Related
Sep 19, 2012
Is it possible to create a validation for tabular form which will be fired only for created?
There is a possibility in APEX 4.1 to choose two types of "*Execution scope*" first is "*For created and Modified Rows*" and second is "*All Submitted Rows*".
View 3 Replies
View Related
Oct 17, 2012
In Apex 4.2, the item validation of "Function Returning Boolean" and "Function Returning Error Text"; They seam to be backwards.
Is there a simple statement that can be used to fix this in the apex dictionary?
View 1 Replies
View Related
Jul 1, 2011
How can "call one trigger of item in trigger of form"
View 5 Replies
View Related
Aug 20, 2012
today I stepped upon an issue regarding popup windows.I have created an application with popup windows for editing and inserting new records.I left the item label templates to "Optional with Help".When I now click upon an item label the help - popup window appears but it is hidden behind the popup window I am working in.
Is there a workaround for that.Is there a possibility to modify the z-order either of the help popup or of the modal window ?
View 6 Replies
View Related
Apr 17, 2012
I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
View 9 Replies
View Related