Forms :: Clienthost - Unable To Block Form When Working On Google Webpage?

Apr 25, 2011

I am trying to open the url from the form and block the form when working on the url.I am able to block the form when working on notepad, adobe and word doc by using the below code

CLIENT_HOST('CMD /C NOTEPAD '||fname);
CLIENT_HOST('cmd /c "c:/web_util[1].pdf"');

and when I use CLIENT_HOST( 'cmd /C "C:/Program Files/Internet Explorer/iexplore.exe" www.google.com'); it is opening the www.google.com but unable to block the form when working on google webpage.

I am using oralce forms 10.1.2.3 and the browser is IE8.

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: Unable To Send Email Through Google To Private Domain

Dec 1, 2012

how to send email (PL/sql Procedure) to private domain through google mail.

View 2 Replies View Related

Forms :: Go Block Not Working?

Sep 18, 2012

In a Entry Screen I Require to Check the Value is Changed or not in a Block (A).

If the Value is Changed then Require to done some validation in another block (B) for take the final entry date and their after going to another Block (C), here user require to enter Some data in it.

I am Using the When Timer Expired in the Block (A) for Check the Value and Going Another block, it working till going another after complete the entry Block (C) I have using a Button for move to Main Block (A), but it not going to the consign block and then i put the Message in it, the message is showing, but not going to the block.

View 1 Replies View Related

Forms :: KEY_DUPREC Is Not Working In A Detail Block?

Feb 8, 2013

KEY_DUPREC is not working in a detail block.What description should i write and where to enable duplication of columns while pressing F3.

View 2 Replies View Related

Forms :: Error 404 On Webpage When Running In 11g

Oct 27, 2011

I am using oracle forms 11g

when i am running a forms the web page is giving error 404-not found.

View 2 Replies View Related

Forms :: Query Mode Not Working At Once The Form Is Opened

Jul 10, 2012

At once when I open the form when I press F11 it is not entering query mode. But if I type something in the text box placed in the form then I press F11 means it is asking "Do you want save the changes you have made?" if I press yes or no, no matter it is going for query mode. How to go to query mode without typing something in it?

View 13 Replies View Related

Forms :: Exit Form Move To Another Block

Feb 3, 2012

We are using Oracle APPS. Currently We develop the Separate Responsibility in it.

In a Entry Screen, it contains three Blocks. During the Close through the Close Button in Top(Like (X)), It move to Another Block after close that window then only the form Closing.

In the same form when we press the F4 it Exit Without that Operation.

View 3 Replies View Related

Forms :: Prevent User From Navigating To Another Webpage By Displaying Dialog Box

Dec 8, 2010

how to know when a user was navigating away from the current open form (and I wanted to prevent the navigation with a dialog box) because they had entered a new URL in the address bar and were trying to navigate to it? I've seen a reference to it from an ADF perspective -> [URL]

but was wondering how to do it within Forms?

The reason for this is that i would want to prompt the user to confirm that they wanted to exit the form as potentially they would have a record (in the form) flagged as being updated and as such no other user (including themselves) could susbequently access it. So, I'm basically wanting to know if there is a way to catch the fact that the user is about to navigate to another web page.

Is it by using javascript and if so, how would it be implemented?

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 :: Unable To Put A Check For A Form?

Jul 5, 2010

I have a leave form where I need to put a check which prevents the user from entering 'sick leave' if the employee hasn't completed 3 months in the company.This is the code I've written:

SELECT ABS(MONTHS_BETWEEN(t.start_date,sysdate)) INTO l_date
FROM hrp_per_all_people_f t
WHERE t.company_id = :parameter.p_company_id
AND t.employee_number = :parameter.p_employee_number

[code]...

The absence_type_id = 21 is for 'sick leave'. I can't figure out why this is not working. When I do enter 'sick leave' for a new employee I do not get any checks and neither am I able to save the changes.

View 6 Replies View Related

Forms :: Calling From Other Data Block Into Current Master / Detail Form

Jun 10, 2013

I got the following scenario.

- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-

Begin

go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......

When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.

View 1 Replies View Related

Forms :: Change Color In Fields In Form Filled Via Data Block?

Jan 4, 2012

I'm trying to change the attributes on a display where the info is gathered via a routine that fills the data block with info. I've searched and tried using 'set item instance property' in several places within the data block using different triggers but still doesn't work.

No errors are encountered or shown. Attributes aren't changed based on a small test condition.

View 2 Replies View Related

Forms :: Unable To Open Form Which Is Created In Another PC

Feb 21, 2012

one of my friend created a form in his PC(which is having the same configuration as my PC) and sent me that .fmb file. when I'm opening that form, it is throwing "FRM-11009 : Failed to load in the color palette" error..

I have checked the CAUPREFS.ORA where Forms.color_mode = 1 and I haven't found 'forms.color_pallete' entry in that file.

View 3 Replies View Related

Forms :: Unable To Make The Form Fields Available To Edit

Jan 30, 2013

My requirement is to call a form through special menu icon from one main form and display some information. Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit. I am displaying a record based on a view.

For that i have used below code in when-new-form-instance

- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');

After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.

I have added below piece of code

set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);

in almost all the triggers and tried. I could still see all the fields are read only.

View 4 Replies View Related

Forms :: FRM-30085 / Unable To Adjust Form For Output

May 20, 2013

"SUM_TOTAL_RECEIVED" ,this is Item name and i set all Calculation Properties correctly and when compile the form , i got an error

FRM-30405: Datatype for Sum/Avg/Variance/Stddev summarized item must be Number.
Item: SUM_TOTAL_RECEIVED
Block: RHCLANDEDCOSTDET_PROMPT
FRM-30085: Unable to adjust form for output.

View 20 Replies View Related

Forms :: Invoice Processing - Unable To Adjust Form For Output

Aug 2, 2011

I've created a form that is working on the basis of Invoice Processing. There I want to get the sum of all the total of the products * quantity..I'm getting this error

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.
Item: TOTAL
Block: SBM_SALES_PRODUCTS
FRM-30085: Unable to adjust form for output.

View 4 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

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

View 0 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

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

Forms :: Multi Data Block And Checkbox Field Based On Control Block

Nov 19, 2010

i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field

e.g

item11 item21 item31 chkbox1
item12 item22 item32 chkbox2

Scenario like this :

My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field

when i checked chkbox1 , my cursor goes to item31...not item32

View 12 Replies View Related

Forms :: Distribute Master Block Total Amount In Detail Block Line Wise

May 5, 2012

i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example

Cheque amount in master block = 291

Invoice wise receiveable amount is as follows

Invoice No , receivable amount , Received amount

10, 196 , 0
20 , 95 , 0
30 , 54 , 0

Result should be as follows:

Invoice No , receivable amount , Received amount

10, 196, 196
20 , 95 , 95
30 , 54, 0

Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.

View 2 Replies View Related

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

Jul 24, 2010

I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.

I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".

View 3 Replies View Related

Form Trigger - Master And Detail Block

Dec 9, 2008

I have a Oracle Form which has 2 blocks, master and Detail.I have a pre-Insert Trigger on master block which has a sequence that acts as the id of the primary key column. Now, when I populate the master block and dont save then go to detail block and save(after populating detail block's data) it gives me an error that can not insert null into detail block foreign key column.I understand that his is happening because in the above scenario pre-insert is not firing for the master block.Am I writing the the sequence generation code in a wrong trigger?

View 1 Replies View Related

Cloud Service :: Webpage Has A Redirect Loop - Resulted In Too Many Redirects?

Feb 7, 2013

I am trying to connect to a cloud account for the first time.BUT I get this error here...This webpage has a redirect loop The webpage at[URL]... has resulted in too many redirects. Clearing your cookies for this site or allowing third-party cookies may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer.

Here are some suggestions:
Reload this webpage later.

View 1 Replies View Related

ORA-27047 / Unable To Read Header Block Of File

Apr 26, 2011

I am trying to create standby with oracle 10g R2 from Solaris 5.10 (sun ultrasparc X86-64 bit) to Solaris 5.10(Intel Xeon 64 bit). All the mount points are the same as primary server. All the data files are at location as specified in control file. I created standby control file from primary. All the control files are at location specified in pfile.

When I am trying to mount database I am getting following error.

ORA-00202: control file: '/oracle/BP1/ctl1.dbf'
ORA-27047: unable to read the header block of file
ORA-205 signalled during: alter database mount...

I try to open database with trace file also but got following error..

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/oracle/BP1/sapdata1/system_1/system.data1'
ORA-27047: unable to read the header block of file

View 1 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Application Express :: Unable To Delete Row(s) From Tabular Form?

Jan 28, 2013

I created report with row selector, when I select one row I get tabular form regarding to the selected row from report. I can insert and update data from tabular form, but I have problem with deleting them. Error I get is

ORA-01403: no data found (Row 207589)

My tabular form is created by wizard and primary key is managed by database rowid, I use apex 4.1 an 10g database.

View 3 Replies View Related

Forms :: Want To Call Web Form For Uploading Image From Custom Form

Apr 16, 2013

I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.

View 1 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Application Express :: Unable To Bind Error In Tabular Form

Jul 5, 2013

I have an application which includes a certain page with a tabular form.After I copied this to a second schema, Apex threw an error

'Unable to bind ':126_ENG_PROJ_ID' 

It took me quite a while before I found out that one of my fields in that tabular form has a Popup Key LOV.The SQL for the LOV was: 

select dv, rv from (select loop_short dv, cmpnt_id rv from SPI_MAIN_TAG where eng_proj_id in (:P126_ENG_PROJ_ID, -:P126_ENG_PROJ_ID) ) order by dv

 Turned out that the view SPI_MAIN_TAG didn't exist in the second schema.Apex error message would have been more clear, like a simple 'Table or view does not exist' error, where possible even with the table name.I had Debug turned on, but in the debug window there was no reference to above SQL,

View 0 Replies View Related







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