Forms :: Restrict Standard Save Functionality?
Jun 20, 2011how can we restrict standard save button functionality in custom form?
View 4 Replies
ADVERTISEMENT
Client Tools :: SQL Developer - Disable Save Password Functionality?
Feb 18, 2011I want to install SQL Developer on a server but don't want the user to be able to store passwords by checking the "Save Password" box.
View 14 Replies View RelatedForms :: GET_FILE_NAME Functionality
Mar 8, 2010I have my forms application working on both windows and Unix platform. When i am using GET_FILE_NAME ( ), it is working fine in Windows based application but the same is not working in Unix based application..
View 11 Replies View RelatedForms :: JTF Grid Functionality
Sep 12, 2009what is JTF GRID functionality,i have use that grid in custom form. how to proceed with that and what are steps to be taken to display JTF GRID Functionality ?
View 6 Replies View RelatedForms :: Auto Stretch Functionality In Oracle?
Oct 6, 2013Is it possible to have auto stretch functionality (similar to Oracle ADF) in Oracle Forms?
The requirement is to adjust the data blocks/ canvases according to the window size automatically.
I know it is possible in Oracle ADF. But I want to achieve the similar kind of functionality in Oracle Forms.
Forms :: How To Restrict Update Of A Block
Feb 22, 2011I want to give update rights of a block to restricted set of people... how can i achieve it???
View 3 Replies View RelatedForms :: Restrict Duplicate Records
Jul 18, 2011there is non database data block of table type.
now i want restrict user that he will not enter same number again.
Forms :: To Restrict Record Deletion
Nov 6, 2011When i opened the form and after querying the records if I press CTL+ Down Arrow the record is deleted.
This is the normal runtime form behavior. When ever pressing CTL+ Down arrow I don't want to delete the record, I tried with KEY-DELREC but it is not happening.
Forms :: How To Restrict Update In S Specific Field
Jul 9, 2012I'm trying to restrict update in a specific field in my form . I have set its property(update allowed) to no and still the field is update able. I am also having on-commit trigger in my form level that well display a message and followed by the command commit. is it possible the trigger is overriding the property(update restriction).
View 9 Replies View RelatedForms :: Restrict User To Access Records
Mar 26, 2012 I am using Forms 6i,Oracle Apps... I have database block.... generally we can retrieve the all the records by press F11 and Ctrl F11.... but my requirement is i have to restrict the user that they can access the records based on the condition ...
For example....let we take emp table....I have to restrict the user that they can query dept no 10 employees only.
Forms :: How To Restrict User On Key Next Item Trigger
Sep 16, 2011SQL Plus version Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 Production
Forms Version : 6i
Reports Version: 6i
O/S : Microsoft Windows Xp professional Version 2002 Service Pack 3
With reference to the above version details here is the requirement. How do I restrict user on key next item trigger i.e I want the cursor to move to next field only when user presses "ENTER" button on the key board any other key like mouse should not allow user to move to the next field.
Forms :: Restrict Field After Insertion Before Commit?
Nov 9, 2010Restrict field after insertion before commit. i mean when user inputs the data in one field and moves to next field.when ever he want to return back on the previous field it can't be edited.before commit;
View 2 Replies View RelatedForms :: Tabular Form - Restrict User To Enter Only 10 Rows
Dec 18, 2012i have master and detail form. In detail(tabular form) i want to restrict user to enter only 10 rows.if he tries to go for 11th row he shud get a message (Only 10 records can be created at a time).
View 3 Replies View RelatedForms :: Restrict User To Enter Serial Numbers Of Product In 3 Level Block
Apr 24, 2012I have a sale invoice form with 3 data blocks.
Data block 1- master_blk : For date/customer of sale invoice
Data block 2- detail_blk1 (detail of the master block - For products and qty)
Data block 3- detail_blk2 (detail of DETAIL_BLK1 For entering serial numbers of products)
My requirement is that whatever quantity user enter in data block 2 against each product he must enter equal number of serial numbers of that product in data block 3.
For this I have created on item (cnt_iteml : to count product's serial numbers in block3 ) in data block 2, and on summary item (t_serial_no ) in block3.
Whenever user changes in quantity, cnt_iteml: item is populated with t_serial_no in block3 of that product by following trigger on quantity column.
POST-Change Trigger ( quantity column )
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
Following trigger is written on block level at data block-3 to populate cnt_iteml with t_serial_no.
PRE-RECORD
IF GET_BLOCK_PROPERTY('SERIAL_NUMBERS',STATUS) IN ('CHANGED') THEN
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
END IF;
Above triggers are fulfilling my requirement except following condition.
If user after entering serial numbers in block 3 and without saving goes back to block2 and try to navigate to another record he gets a message asking him to save changes by forms. At this time if user presses no then cnt_itl item is not been populated with t_serial_no item's value.
What I want in above condition is that if user was inserting new record cnt_it item should be populated with 0, so that he shouldn't be able to save this record. And If he was updating then cnt_itl item should be populated with actual no of records in database against that product.
Forms :: Convert It Into Standard Date Format?
Jun 3, 2010i have create one standard Calender from that i pickup month date and year separately like 2/6/1987 now i want to convert it into standard date format how to convert it and pass to another block....
View 3 Replies View RelatedForms :: How To Implement Custom Lov Button Without The Standard Template.fmb
Jul 4, 2010i am developing a application using oracle forms 10g. i can't use the standard template.fmb because my application does not run in ebs. there comes the problem: i want to implement the lov button function like the template does, such as :
1. when the text item get focus, lov button display.
2. when the text item lost focus, lov button disappear.
3. when scrollbar scrolls, the position of lov button adjust accordingly.
4. there is only one lov button in one form and the lov button was created dynamically.
Forms :: How To Have Standard Size For Canvas Or Window Of Form
Feb 28, 2012Is 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 RelatedForms :: Customizing A Standard Form To Allow User To Copy Values
Dec 18, 2012I am customizing a standard form to allow user to copy values. It works fine when I open the form, query a record and hit copy. But if I copy something to the clipboard from the records before I hit copy button, the form behaves differently and throw errors. Can I do something before the copy procedure work to eliminate this error?
View 3 Replies View RelatedForms :: FRM-40202 - Field Must Be Entered (after Standard Form Had Been Modified)
Apr 14, 2010I got an error FRM-40202: Field must be entered. I did some modifications to Standard form by copying it. after that when I selected the first Email check box in the list and then selected the Email button which I created newly for that form.
View 1 Replies View RelatedForms :: Do You Want To Save Record
Aug 22, 2005I have created a form which as two block as master and detail.I am facing two problem in my detail block.
First: When I populate records in detail block, it prompt a message 'Do you want to save record ?'.
Second : When I alter any value in detail block and move to next record, it prompt a message 'Do you want to save record ?'
Is there any way where, system don't prompt me a message for saving record and user can continue with changes and save the records when he desire.
Forms :: Unable To Save Record
Oct 21, 2010the data not save the record the item CMPID not generate a number or id to press button NEW
secondly to click the button SAVE they not save the partcular transaction.
Forms :: Save Only Edited Or New Records
May 16, 2010I have a block based on a table and display a few records on the form after retrieving records from the table behind. Now I should be able to edit a record or add a new record to the existing records on the screen. So when i click the save button I only want the rows which are new or have been edited to go back into the db. This is the piece of code I was using for the save button in the on-button-clicked action.
IF alert_button=alert_button1 THEN
GO_BLOCK('my_block');
IF NOT Form_Success THEN RAISE Form_Trigger_Failure;
END IF;
/* ** Commit if anything is changed */
IF :System.record_Status IN ('CHANGED','NEW') THEN Commit_Form;
END IF;
msg_info('Your changes have been saved.');
END IF;
When I do this all the records on the screen gets inserted into the table instead of only the one's I have edited or newly inserted. I only want to insert rows which are new or edited into the table after I click the save button.
Forms :: Disable Save Button In 6i
Jul 22, 2011I am working on form 6i. I want to disable the 'SAVE' button which can be seen in the menu (front end).
View 2 Replies View RelatedForms :: Save Button Works Only Once?
Jun 26, 2012declare
blk_name varchar2(60);
form_name varchar2(60);
[Code].....
this is my coding on save button. this is working fine but only once. when i enter the data second time and try to save, it didn't do anything. what should i do?
Forms :: Update First Then Save The Form
Apr 25, 2012I make button in detail section using this location button call another forms, I want first update the location entry then save our main forms.
View 3 Replies View RelatedForms :: Save Images In Database From 6i
Mar 16, 2006 I have seen many times that people are confused for how to save and retrieve images in Oracle Database from forms. Here I have created a sample form. All the coding is there. And also required scripts are also written in this post. Please download the form create the scripts and run the form.
Here we go:
Database : 9i
Forms : 6i
Create Scripts:
CREATE TABLE DOCS_COMP_DOCUMENTS
(
DOC_ID VARCHAR2(10),
DOC_NAME VARCHAR2(100),
DOC_SCANNED_COPY LONG RAW,
FILE_NAME VARCHAR2(50),
FILE_EXTENSION VARCHAR2(3)
)
[code].......
Note: This Procedure is to find the file name and extension and store it as well in database. Create this procedure in database.
To retrieve images just press F7 & F8 in forms
Download the attached .fmb module and run it.
Forms :: How To Save Multiple Records At Once
Jun 3, 2013how to save multiple records at once i did coding like this:
declare
cnt number;
l_rec number;
f_rec number;
begin
cnt := 0;
go_block('aan');
last_record;
l_rec := :system.cursor_record;
first_record;
[code]....
but this works as saving the last record only, not saving the all records.
Forms :: FRM-40401 No Save To Change?
Jun 17, 2011I have updated a table from the form and written a update statement ON block level trigger ON-UPDATE
"UPDATE_RECORD;
update employees set hiredate=to_date(:EMP.TXT_DATE,'dd-MON-yyyy')
where employees.empno=:emp.empno;
COMMIT_FORM;"
Here employees is my table and emp is my block
Forms :: Location And Save Button
Apr 25, 2012I have a master-detail form on which i have 2 buttons. save button and another location button in detail.on location button i am calling a form and updating location of the material entered in detail(tabular).
The thing is my form should not get save without updating location for each record entered in detail(tabular).if user try to save form without updating or pressing location button it should give message PLEASE UPDATE YOUR LOCATION.
Forms :: Create One Save Button
Jun 16, 2011I have created one form with control block and database data block.here i have created one save button based on that i have to save records both control and database block in database block table.If i i write commit_form record will be saved on different rows in a table means control block record in one row and datablock record in one row.But i want to update in one row(one line) in a table.
View 2 Replies View Related