Forms :: Location And Save Button

Apr 25, 2012

I 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.

View 23 Replies


Forms :: Disable Save Button In 6i

Jul 22, 2011

I 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 Related

Forms :: Save Button Works Only Once?

Jun 26, 2012

blk_name varchar2(60);
form_name varchar2(60);


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?

View 5 Replies View Related

Forms :: Create One Save Button

Jun 16, 2011

I have created one form with control block and database data 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

Forms :: Trigger On Save Button

Oct 31, 2013

which is the trigger that fires when we Press the Standard 'Save' button from the toolbar? And i want to update the record on another table which is not in data block by using this save button? @ that time i want to display message like transaction complete:1 records to do this?

View 24 Replies View Related

Forms :: Disable SAVE Button

Apr 20, 2010

I have created a form using data block wizard and lay out wizard. I want to disable the SAVE button, I gave the following in Triggers WHEN-NEW-FORM-INSTANCE


but when I run the form it displays this message at the bottom of the screen

Frm 41045:Cannot find item invalidID.

View 2 Replies View Related

Forms :: Adding A Save (Update) Button

Nov 28, 2012

I have one form where I have let's say 2 items that I want to manage. One is a List Item and the other Text Item. Both are based on one table. The List Item is not updatable (Update Allowed is set to NO) and there I have some types of houses for example (T -> tall house, B -> Big house, S -> Small house it's not important so much) and the Text Item is for counting the types for example we have 4 houses of type T and if we add another one in the textItem we will see 5, so it's not counter for all houses but it counts types of houses and that item is not updatable nor insertable (Update allowed and Insert allowed are set to NO) so it's only purpose is just to show how many hauses we have of particular type and automatically increases the number if we insert new house. Beside this two items I have another Items that conatin some informations about the house (How many flats, doors, windows, and so on..). you've got the picture of my form and table.

Now I want to add one button with trigger WHEN-BUTTON-PRESSED that will do this. If I want to change the type of the house after I inserted it and save it in the table, I have to just change the type in the List Item (choose another type) and press the button to save the same house with the same properties I would say (How many flats, doors, windows, and so on..) but with another type. First when I press the button it must ask me if I am sure that I want to make that change (I'll make an allert fot that) and if I press OK or Yes my house will be saved just with the different type and the previous house with the previous type must be erased. And in the textItem 'the counter', the number of the new type must encrease for one and the previous type must decrease for one.

I hope you understand what I want to do and all I need is that trigger to manage this problem of mine. I know it's possible to do but I am quite new in DB programming and I am not very good with programming in PL/SQL.

View 6 Replies View Related

Forms :: User Click On Radio Button To Save It On DB

May 2, 2010

i have field in DB that taken ( 1 or 2 or 3 ) am added it as text item at first and then change it to ( radio group ) contain 3 radio as :

value for first 1 = 1 , = 2 , = 3 and mapping = 1
initial value for the group = 1

but when am working with the form and commit form there is no data add in this field when am change the radio value by click on any other on ( 2 or 3 ) it's saved no problem in it ..

why this thing happen coz i need to set the first radio as default for the form .

View 1 Replies View Related

Forms :: How To Insert Values Through Blocks Using Button (save)

Dec 15, 2010

I HAVE 2 BLOCKS E.G. MASTER-DETAIL AND i have created it manually then how to insert values thrugh these blocks using a button called "save" using "commit_form;" suppose form fields are

emp name
detail block:
where emp_id is primary key as well foreign key in detail table

how these values will be inserted in both tables

View 1 Replies View Related

Forms :: Blank Line Getting Generated On Save Button

May 31, 2013

I am working on Oracle forms 6i. I am getting a problem when I am trying to save the value in the form.

Well the scenario is like this:

I have got a multi record block. In that block there are two items jobno and inoivce no. Both the items have an LOV attached to them giving jobnos and invoice nos respectively.

This is on the '*ORIGINAL_BLOCK*'.

The problem perists with the jobno field. In the LOV for jobno, the 'column mapping properties' property, the return item section has original_block.jobno as the value. The code to fetch the details about the jobno (like vendor no,vendor site,invoice no etc) has been written on the When-Validate-Item trigger. I am also updating the WHO colums(like created by,created date,last upated by, last update date) on the Pre-Insert trigger at the block level. This whole thing of fetching the records is working fine. But when I simply press the save button an extra blank line gets generated on the form as well as at back end with jobno like this:

Sr.noJOBNO vendor_no vendor_name invoice_noinvoice_date
1 123 37456 abc 4564565 26-APR-2013 --- correct entry
2 123 8574 xyz 645656 26-JAN-2013 --- correct entry
3 123 --- --- --- --- unrequired blank entry

A same jobno can have multiple number of invoices. So the lines getting generated are - number of lines + 1(unrequired entry).As in the above scenario there are only 2 invoices for the same job and a third unrequired entry getting generated. If there are 3 invoices I get 4 lines (3 required + 1 unrequired blank entry).

So to solve this issue I added a button 'Add JOB'. I took another '*NEW_BLOCK*',designed another canvas and and added an item on it containing a dummy jobno field and attached an LOV to that item. Then the same When-Validate-Trigger to that item fetching the details. so when I press the button 'Add JOB' using show_canvas and go_item(dummy_job_item) I navigate to that new canvas, select the jobno there from LOV, fetch the details. Now I wrote execute_query on KEY-EXIT of the NEW_BLOCK so that whatever are the fetched details, they would go on the ORIGINAL_BLOCK.jobno and respective details in resp fields. But this did not work.So I wrote execute_query on the When-New-Block-Instance of the ORIGINAL_BLOCK and it worked.

But now what is happening is when I open the form once again after closing the form, all the back end data is appearing on the form i.e. when I open a new form session every time. But I want the form to be clear with no entries displayed whenever I open the form. I understand the question is lengthy and tricky.

View 1 Replies View Related

Forms :: Run Concurrent Program On Save (Push Button)

Jun 16, 2011

How can we run concurrent program on SAVE (push button) in oracle forms?

View 3 Replies View Related

Forms :: Disable Save Button After The Sequence In Generated?

Feb 2, 2013

i have master-detail form in which i am generating sequence number as my bill no. on save button.

i want to disable save button after the sequence in generated.

View 1 Replies View Related

Forms :: Windows Close / Click On Save Button Data Get Saved

Jun 29, 2010

i design one master detail block and one command button for saving the i click on save button data get saved and after that if i want to close form then at this time it again asking me for save changes window..

View 8 Replies View Related

Save Button On A Form / SQL Plus Transactions

Jan 22, 2013

When a user clicks on Save Button on a form, can we know from sql plus (Oracle) all the related queries (insert/Update etc) for that transaction ??

View 1 Replies View Related

Application Express :: HTML Text Area With Save Button

Oct 22, 2012

I have created a region Q_INFO and in the region i have added HTML text area. This text area is editable for only few users. If the user types in the text area and presses save button. The text is stored in the table INFO. And this text is displayed to all other users. But when i enter any data in the text area with multiple new lines and press SAVE button. The text is displayed in single line. I want to maintain new line and paragraph in the text area.

View 2 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 Replies View Related

Forms :: Copy Files From One Location To Another In 6i

Sep 9, 2008

I want to copy files from one location to another in forms6i on when button pressed.i m using the following code.

cpf_source VARCHAR2(500) := 'c: est.txt';
cpf_target VARCHAR2(500) := 'c:data';

But i press the button it generates FRM-40734,

internal Error : PL/SQL error occurred.

View 5 Replies View Related

Forms :: Get Block Name From Cursor Focus Location?

Jul 27, 2010

I have a delete button at the bottom of the form and have two blocks on top of it. I need to know which block i have the focus on or selected the record on pressing the delete button so that I go to that block and do a delete_record from that block. I came across :system.trigger_block which says it gives the name of the block where the cursor was located when the current trigger initially fired. But whenever i use it only returns the name of the block the delete button is located in. Instead i wanted to know where the focus of the cursor was or which record was selected in the above 2 blocks to go to that block and delete the record.

View 1 Replies View Related

Forms :: Data Copy Into Other Location On Daily Basis

May 22, 2010

I need any good suggestion basically I have two different location

1- Factory
2- Head office

I have developed PRODUCTION module in factory and it is working fine and now I want to send data on daily basis to head office therefore I develop a form which will create backup in export format (.dmp) then user will send via email to head office.

Backup file should be save in pre-defined location then user will use a form which I developed for loading data into head office there are two different buttons in this form;

First is used to load data, actually first I load data in a temporary user which creates whenever user will press this button. Second is used to copy data in application user but first it checks if data exists then update otherwise insert.

View 1 Replies View Related

Difference Between (ocrconfig -export Location) And (ocrconfig -manualbackup Location)?

Aug 13, 2013

what is difference between "ocrconfig -export location" and "ocrconfig -manualbackup location"

View 1 Replies View Related

Forms :: Do You Want To Save Record

Aug 22, 2005

I 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.

View 16 Replies View Related

Forms :: Oracle 6i For Windows 7 64 Bit / Can't Find Exact Location From Google

Sep 20, 2012

i want to download form 6i and report 6i for window 7 64bit. from where i can download it. i can't find exact location from google.

View 6 Replies View Related

Forms :: Unable To Save Record

Oct 21, 2010

the 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.

View 12 Replies View Related

Forms :: Save Only Edited Or New Records

May 16, 2010

I 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
IF NOT Form_Success THEN RAISE Form_Trigger_Failure;
/* ** Commit if anything is changed */
IF :System.record_Status IN ('CHANGED','NEW') THEN Commit_Form;
msg_info('Your changes have been saved.');

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.

View 5 Replies View Related

Forms :: Update First Then Save The Form

Apr 25, 2012

I 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 Related

Forms :: 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:


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.

View 39 Replies View Related

Forms :: How To Save Multiple Records At Once

Jun 3, 2013

how to save multiple records at once i did coding like this:

cnt number;
l_rec number;
f_rec number;

cnt := 0;
l_rec := :system.cursor_record;


but this works as saving the last record only, not saving the all records.

View 4 Replies View Related

Forms :: FRM-40401 No Save To Change?

Jun 17, 2011

I have updated a table from the form and written a update statement ON block level trigger ON-UPDATE

update employees set hiredate=to_date(:EMP.TXT_DATE,'dd-MON-yyyy')
where employees.empno=:emp.empno;

Here employees is my table and emp is my block

View 6 Replies View Related

Forms :: To Save Multi Tab Form

Oct 3, 2011

I have a multi tab form. When I open any form; the form no. and form lists are automatically uploaded. I can enter the rest of the data and save the form. The problem is; if I try to open another tab(form), system did not allow it and ask to enter data in the already open form fields. I can only save the form, which I open first.

View 2 Replies View Related

Forms :: Restrict Standard Save Functionality?

Jun 20, 2011

how can we restrict standard save button functionality in custom form?

View 4 Replies View Related

Copyrights 2005-15, All rights reserved