Forms :: Delete_record Not Removing Record From Screen

May 13, 2010

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

View 4 Replies


ADVERTISEMENT

Forms :: Delete_record In Block

Oct 26, 2011

I have form same picture under, and i would delete record already checked on tabular when click button DELETE .

View 5 Replies View Related

Forms :: How To Position Center Customized Logon Screen In Web Forms

Nov 20, 2012

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

View 3 Replies View Related

Forms :: Bypass Log On Screen In 6i?

May 14, 2011

i want to bypass the logon screen in forms 6i i have trigger but it not works.

View 1 Replies View Related

Forms :: Logon / Logout Screen

Feb 3, 2012

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

View 1 Replies View Related

Forms :: Unable To See A Canvas On Screen?

Aug 6, 2010

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 Related

Forms :: How Screen Can Be Center Oriented

Jul 1, 2010

how the forms webpage/forms screen can be center oriented which is by default top left oriented in the content webpage.

View 1 Replies View Related

Forms :: Unable To Get Whole Form On Screen

Mar 22, 2011

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

Forms :: Migrate Reports 6i To 11g Screen

Mar 21, 2013

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

View 5 Replies View Related

Forms :: Bypassing The Login Screen?

May 11, 2010

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.

View 3 Replies View Related

Forms :: 10g Screen Not Printing Through Citrix?

Mar 24, 2010

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 Related

Forms :: Image On The Form For Splash Screen

Dec 4, 2009

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

View 3 Replies View Related

Forms :: Screen Not Open - Application Stuck

Jul 6, 2013

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 Related

Forms :: 10g Show Empty Screen In Browser?

Jun 29, 2012

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

View 9 Replies View Related

Forms :: Maximize Window On Secondary Screen

Aug 20, 2012

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

Forms :: Removing Image From Data Block

May 9, 2010

While there's numerous QAs about inserting an image into the DB using the Data Block, how does one remove an image? Obviously there's the "UPDATE ... SET X = EMPTY_BLOB();", however, that kills the Data Block/Form's flow, and it doesn't update.

I've tried a few things:
* :CONTROL.IMG1 := NULL; (bad bind variable)
* :CONTROL.IMG1 := EMPTY_BLOB(); (some other error, probably as above)

View 2 Replies View Related

Forms :: How To Set Window Size Which Should Be Compatible For Any Screen Resolution

Mar 30, 2011

Actually i am migrating forms from 6i to 10g Here i need to set the window which should be fit in the browser(internet explorer) resolution and it should be compatible for any resolution?

i have tried by changing width and height in formsweb.cfg file but it is not compatible for different resolutions...

View 1 Replies View Related

Forms :: Removing / Changing Form On Server Does Not Affect Anything?

Sep 15, 2011

Actually, i found that some forms if they are changed (like some buttons/text fields/code added to them) and this change can be saved and there is no errors in compilation. but when this form is run from the application, the change is not visible.

Even if the form with the image is removed from the directory, it still runs from the application link. Is there some memory issue or anything else.

View 2 Replies View Related

Forms :: How To Connect Excel With Oracle Database Via 10g Login Screen

Jul 20, 2010

In fact I have around 50 excelbooks that are connect with oracle via ODBC/or any other way. My task is to build the login screen on form 10g. This form will validate the user via .dll after successfully validation, Form will connect to specific oracle user. This Login Screen will call the new form that will execute the query for the list of excel sheet [table that will keep the name, description and path of the excelbook]. User will select the one excelbook to open. As user will select Excelbook should be open. Now this excel book should be connected with specific oracle user.

Question 1: How to open the excelbook, that excelbook should be connected via form 10g login screen. After connection excel has its own micros to run he query from oracle database.

Question 2: How I can create the mirco into form 10g to run into excelbook/excelsheet.

Question 3: How I can pass the query or function/procedure to the excelbook/excelsheet.

View 3 Replies View Related

Forms :: Customize Position Of ALERT Message On Screen As Per Requirement

Mar 19, 2010

I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.

View 4 Replies View Related

Forms :: When Pressed F-11 And Ctrl F11 Buttons Screen Doesn't Turn Blue

Oct 19, 2009

I developed custom form, everythng is working fine. but when i press F-11 & Ctrl F-11 it queries and gtes the record.

But when I press F-11 ,fields on the screen doesnt turn blue.

View 10 Replies View Related

Forms :: Open Test Form In Oracle 10g Only Internet Explorer Is Opening With Blank Screen?

Apr 26, 2010

I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).

Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...

View 2 Replies View Related

Forms :: Populating Values To Record Group From Multi Record Datablock

Jul 26, 2012

My procedure proc_ex is in when_validate_item trigger

I have one Multi Record data block in my form with values in its items

I need to Populate multi record block values to one Record Group using

add_group_row,
add_group_column,
set_group_char_cell to populate values to record group

Let us suppose my multi record data block looks like

item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80

how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies

View 3 Replies View Related

Forms ::create History Record For Each Record Whether Updated Or Not

Sep 13, 2011

I have a fairly standard Purchase Order form which contains pre-loaded data (been uploaded from an XML file).When the Purchase Order is processed, the form updates a Price History table only if the Price on the PO_Details changes.The code for updating the price history table is contained in a PRE_UPDATE trigger on the PO_Details Data Block.

No other data changes on the PO_Details table.I now want to change this so that the Price History table is updated even if the price does not change i.e I want to create a history record for each record on the PO_Details irrespective of whether it was updated or not.

Is there an alternative trigger that I can move my code to (ie move it from PRE_UPDATE) to some other trigger that is fired for each PO_Details record even if there is no change.

View 4 Replies View Related

Forms :: Only New Record Have Saved Last Record No Longer Exist

Jun 29, 2013

I create a data block on a table when I am inserting new record only one record have been saved. Last record no longer exist.

View 4 Replies View Related

Forms :: Choose Lov In First Record That Won't Be Display In Second Record Lov

Sep 10, 2012

I have one multi record block in that i have one LOV..If i choose lov in first record that won't be display in second record lov...

View 4 Replies View Related

Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table

Dec 25, 2011

when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.

View 8 Replies View Related

Forms :: Insert Record Into Lov Through Oracle Custom Forms?

Oct 8, 2013

I have a LOV in a custom oracle forms.this lov is linked to a record group.

Presently the column on which lov is created does not contain any value.

I want to insert value into the lov through the forms.

I am not able to insert data into it through forms

View 12 Replies View Related

PL/SQL :: Removing Duplicates Except One

Sep 19, 2013

db and dev 10g rel2 ,suppose that i have a table with a lot of duplicate rows ,what i need is to delete the duplicates and retain one row of these duplicates . likecolumn -- with those values...how to delete two (hi's) and retain the third , ?it is all applied to all the duplicate values in the column.

View 5 Replies View Related

Removing Duplicate Keys

Jul 3, 2008

Trying to delete duplicate rows from a table. The problem is, they aren't exactly duplicate rows. Let me explain.

I am migrating data from a Oracle 8.1.7 db to a 10.2.1 db. In the older db, this certain table does not have a PK/Unique Index, but in the new db there is a unique index. The fields that the index is unique on are:

SUBSCR_NO, SUBSCR_NO_RESETS, EXTERNAL_ID, EXTERNAL_ID_TYPE, ACTIVE_DATE.

In the old db, when I run this query I get 1229 rows. With a count of 2 each.

select SUBSCR_NO, SUBSCR_NO_RESETS, EXTERNAL_ID, EXTERNAL_ID_TYPE, ACTIVE_DATE, count(*)
from customer_id_equip_map
group by SUBSCR_NO, SUBSCR_NO_RESETS, EXTERNAL_ID, EXTERNAL_ID_TYPE, ACTIVE_DATE
having count(*)>1;

They are duplicates on those fields, but they are not totally duplicate rows because there is a field called is_current that has 0 in one row and has 1 in the other. What I need to do, is delete the 1229 rows with is_current=0.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved