Forms :: How To Make Calculator In Oracle 6i Or 10g

Jul 22, 2013

Is it possible to design calculator in oracle forms 6i or 10g?

View 2 Replies


ADVERTISEMENT

Forms :: Make Calendar In Oracle 10g

Sep 15, 2011

I want to make calendar in oracle form 10g, but i don't know make it. How to do make calendar?

View 2 Replies View Related

Forms :: How To Make Oracle Application Always On Top

Feb 13, 2010

I want to make oracle application "always active" or "always on top" automatically when windows logon as feature provided in task manager.

View 2 Replies View Related

Forms :: How To Make Browse Image In Oracle 10g

Apr 17, 2011

how to make browse image in oracle form 10g?

View 1 Replies View Related

Forms :: How To Make A Calendar

Mar 4, 2003

I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?

View 20 Replies View Related

Forms :: How To Make A Node

Feb 27, 2012

How to make a node of a Hierarchical Tree BOLD without intervene java code ?

View 1 Replies View Related

Forms :: Make Field Non Editable

Jul 29, 2010

I have a field on the form which is a database field and the value is populated by a LOV. The user should not be able to edit the value selected or enter his own values in the field. Basically the field should only be populated by the lov and should not be editable.

I tried using the SET_ITEM_PROPERTY('XX.XX', UPDATE_ALLOWED, PROPERTY_FALSE); but this only disable update against existing value. If a user selects a new value from LOV that can be edited.

View 8 Replies View Related

Forms :: Make Cursor At The Item

Jan 25, 2013

I have a button "clear" , I want when the button is clicked the items will be cleared and the cursor is at the first item, here is the

:emp.id:=null;
:emp.ename:=null;
:emp.sal:=null;
go_item('emp.id');

=>but the problem that the item changes color, but the cursor remains at the button "clear"

NOTE:
I used the "when-new-item-instance" trigger to change the color of text items

View 3 Replies View Related

Forms :: Make One Form For Many Systems

Mar 4, 2013

make one form for many systems i have (i.e) I need to make it like portal many button for many systems When i enter the button i login to specified system (i.e) I need to make new connection to this schema and disconnect the previous one.

View 1 Replies View Related

Forms :: How To Make Block Query

Jan 30, 2012

I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.

View 12 Replies View Related

Forms :: Make Field Protected Against Update?

Apr 29, 2011

What i am required to do is to protect a field 'COUR_CODE' from update when the SHIP_METHOD='R'. c

if :system.record_status = 'INSERT' then
declare
vcour_code ACCOUNTS.cour_code%type := NULL;
vcourier_account_no ACCOUNTS.courier_account_no%type := NULL;
canvas_name varchar2(30);
begin

[code]....

View 11 Replies View Related

Forms :: How To Make Query Mode Work (f11)

Apr 2, 2012

I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.

View 18 Replies View Related

Forms :: How To Make Demand Wise Report

Jul 3, 2013

I have a payment table that has the ids of cds that has being sold in the past month. From there I want to make a demand wise report. I am aware of the report wizard in the oracle forms but I dont want to use it. Here are the tables in a bit more details.

payment: id_cd, price, dateofsell
cd_details: id_cd, name, price, language.

View 6 Replies View Related

Make Oracle Tree In Specified Format?

Apr 6, 2013

---------------------------script of table for tree--------------
create table eqpt_mast
(
EQPT_ID VARCHAR2(16),
EQPT_CODE VARCHAR2(9),
PARENT_CODE VARCHAR2(9),

[code]....

output of tree like:-
grandf(0)
|__
---father1(1)

[code]...

i want to make tree like the above format.In the above tree "(value)" shows the code_type i.e. level of the tree..

version----Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

View 2 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 :: Make Print Button To Display Information

Oct 4, 2012

how can i put button in a form to print the information i displayed in this form.

View 1 Replies View Related

Forms :: Make Excel Dump For Some Banking Application Using 6i?

Jun 17, 2010

I am trying to make an excel dump for some banking application using Forms 6i . I am making use of OLE to make an excel dump. I have a small problem while using this OLE concept . I have an Account column which is is having the data type VARCHAR2 at database level . when i try to make a excel dump of this column , then the values in the account number column in excel is getting converted into number column . Eg: A/c - 000123 is appearing as 123 in excel. How this can be retained as 000123 in excel sheet .

test case -

actual value appearing value in excel
000123 123

code extract in hv used -

args := ole2.create_arglist;
ole2.add_arg(args, rowcount);
ole2.add_arg(args, colcount);
cell := ole2.get_obj_property(worksheet, 'Cells', args);
ole2.destroy_arglist(args);
ole2.set_property(cell, 'Value', rec1.BANKNR);
ole2.release_obj(cell);

View 1 Replies View Related

Forms :: Make Push_button To Act As Browse Pictures Files?

Feb 19, 2010

How i can make a push_button to act as browse the Pictures files only to upload in Image Box. At Commit store in my Database.

View 1 Replies View Related

Workflow :: How To Make Node To Deferred In Oracle

Aug 17, 2012

How to make node to deferred node in oracle workflow ?

View 2 Replies View Related

Forms :: How To Make A Date Field Filter In Descending Order

Aug 5, 2011

I have a question regarding a Date field on one of my form.

How do I make a Date field filter in a descending order when the form is opened? Also, can I add a 'when-mouse-doubleclick' trigger to sort the date field in ascending and descending order (this is a client requirement)?

View 2 Replies View Related

Forms :: Make A Field As Mandatory At Current Record Level

May 27, 2010

I have one requirement i.e i want to make a particular item as mandatory for the current record in the tabular form.

so i have written code as below:

DECLARE
lv_item item;
BEGIN
lv_item := FIND_ITEM ('XXMZ_DETAIL.QTY_ACT');
SET_ITEM_INSTANCE_PROPERTY (lv_item,
current_record,
required,
property_true);
END;

This code is not effecting qty field. If i write set_item_property built-in that item becomes mandatory.But it's not effecting at current record level.It's effecting block level.

So how can i make a field as mandatory at current record level?

View 7 Replies View Related

Forms :: Conversion - Make It Accessible Based On Browser To Clients?

Jul 6, 2011

i have developed an oracle form application in oracle developer 10g, now i want to make it accessible based on a browser to the clients(make it a web aaplication form)

View 3 Replies View Related

Forms :: How To Dynamically Make Visible True Or False In Menu

Apr 12, 2011

I am unable to hide or make visible a menu item dynamically. I want to show a menu to a bunch of employees only.

I have tried:

On the menu properties, I have done:
Physical-> visible : No
functional -> visible in Menu: No
(Have tried different combinations too)

On the form where this menu is attached, I have written trigger new form instance:

SET_MENU_ITEM_PROPERTY('mymenu.menu_name',visible,PROPERTY_TRUE);

Its working fine when I am trying to enable or disable the same but I have to do it the desired way.

View 4 Replies View Related

Forms :: How To Make Button Visible Property False By Clicking On It

Apr 3, 2013

I want to show or hide some items on my form by using the SET_ITEM_PROPERTY to enable or disable VISIBLE. i have a button NEW, my need is when i click on this NEW button it should be hide and some other items should be show. but when i click on this its only showing other items but not hiding the NEW button. my NEW button is like this:

[b]set_item_property('select.new',visible,property_false);
set_item_property('select.new',enabled,property_false);
set_item_property('select.new',navigable,property_false);[/b]
------------------------------------------------------------------
set_item_property('control.section',visible,property_true);
set_item_property('control.section',enabled,property_true);
set_item_property('control.section',navigable,property_true);
set_item_property('control.year',visible,property_true);
set_item_property('control.year',enabled,property_true);
set_item_property('control.year',navigable,property_true);

View 3 Replies View Related

Reports & Discoverer :: How To Make Subscript In Oracle Like In MS Word

Jun 17, 2011

How to make subscript in Oracle like in Msword

View 1 Replies View Related

Forms :: Hierarchical Tree - Make Information System Of Subjects And Corresponding Section?

Jan 26, 2012

I want to make an Information System of Subjects and its corresponding sections.Below is my desired output:

+ Sections
- Section 1
- Advanced Algebra
- Physics
- Section 2

[code]...

I wanna do it in a hierarchical tree, since I don't know how to do it,

View 28 Replies View Related

Backup & Recovery :: Make Copy Of Oracle Database In Local PC

Feb 3, 2011

I want a copy of data from oracle database in Production to my local machine as upgrade is going to be there soon. How can I do that so that I may check my old data later irrespective of upgrade?

View 9 Replies View Related

Application Express :: How To Make Use Of SSO Login Credentials Of Oracle In Authentication Schema

Jul 16, 2013

I am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.

View 0 Replies View Related

Pivot Query In Oracle To Get Years From Column And Make Separate Column For Each

Jul 22, 2009

I'm trying to do a pivot query in oracle to get the years from a column and make a separate column for each. I found an example of the code to use on the internet and i changed it for my own tables but i'm getting errors. Namely a "FROM keyword not where expected" error at the beginning of the 'avg(...' statements.

I have copied the code used in

select stud_id, 2006, 2007, 2008, 2009
from (
select stud_id,
avg(case when year=2006 then ((present/poss)*100) else null end) 2006,
avg(case when year=2007 then ((present/poss)*100) else null end) 2007,
avg(case when year=2008 then ((present/poss)*100) else null end) 2008,
avg(case when year=2009 then ((present/poss)*100) else null end) 2009
from attendance.vw_all_attendance_perc
group by stud_id
);

View 11 Replies View Related

SQL & PL/SQL :: How To Make PK Not To Validate

Nov 21, 2011

i am writing a script for inserting rows in a table where primary key of that table consists of 4 columns. I want to add a new row where 3 columns of that table will be same but change the value of the last one. this is giving an error saying that i am violating the unique constraint. I tried to disable that constraint/PK by following statement but still this error is coming

alter table sections_budgets modify primary key disable cascade;

OR

alter table sections_budgets modify constraints sec_bdgt_pk disable cascade;

the insert statement which i am using. The first four columns are part of PK

insert into sections_budgets (SELECT sb.bdgt_cd, sb.bdgt_dpf_cd, sb.bdgt_yr, :sec_code, sb.usf_usr_id,
sb.aty, sb.comaty, sb.comytd, sb.expn_ytd, sb.sys_dt, sb.cat,
sb.start_aty, sb.expn_lmt
FROM sections_budgets sb
WHERE sb.bdgt_dpf_cd = :b_d_code AND sb.bdgt_yr = :year);

is there any other way of inserting records in this table without droping the whole table because it contains too many triggers and constraints?

View 24 Replies View Related







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