Forms :: Change The Cursor Style?
Jan 11, 2012To change the mouse pointer in D2K, which is the built-in to be used?
View 1 Replies
ADVERTISEMENT
Forms :: Change Cursor Style Into Busy Mode During Process
Mar 31, 2011I have one form in which I need to change cursor style to busy while doing some process and after completing that process cursor should get to default.I have done changing cursor style but during its busy state it is allowing me to change values or click buttons.It should not allow user to change anything or click any button.
View 1 Replies View RelatedForms :: How To Display Password In Symbol Style
Dec 14, 2011i want to make a form from creating new user and password but i don't know how to display password in *** style and how to save it with s-key character.
View 1 Replies View RelatedHow To Create Cross-tab / Matrix Style Output In Forms
Sep 16, 2011I am essentially trying to reproduce an extremely complex spread-sheet with an engineering mathematical model in it and that has been in use for 5 years now. The Excel spreadsheet was a good environment for tuning the model, but now I have been asked to design an Oracle Form that incorporates their mathematical model and shows their final and intermediate data so they can validate my app against their proven spreadsheet.
To do that I have to create a matrix style table for use as a child data-block in my Oracle Form.
Forms :: Serial Number In Tabular Style Form?
Feb 9, 2010I need Sequence generate in each row in tabular style form
Like
FA0015
FA0016
FA0017
(I dont want to use sequence because when i delete the row its conceder delete row in sequence )
Forms :: Created Block For Table On Tabular Style - Validating Item?
Oct 10, 2011I created a block for EMP table on tabular style. if in first line empno entered is 1then i don't want to allow the end user to enter 1 in second line. but when-validate-item is not working because first_record and next_record is not allowed. I need to validate before saving the data into emp table and immediately after empno is entered into empno item.
View 16 Replies View RelatedApplication Express :: Interactive Report - Break Formatting Style?
Nov 14, 2013,Is there a way to make Interactive reports break format work/look like classic reports break format? i.e.1st,2nd,3rd column option. The way IR breaks is that is reserves a whole row for the column used in the break, which is not what I want, I want the report to look like the following:
city emp sal
Chicago John Miller 1500
Mark Horton 2000
Denver Rob Martino 1200
I tried to use rollup queries which work fine except that it does not do exactly what I want when I sort columns through the front end , I am basically displaying a check box for grouped records ( and I want it to display at the first record of each group), so the order is important. for example:
checkbox City emp sal[ ]
Chicago John Miller 1500
Mark Horton 2000[ ]
Denver Rob Martino 1200
Application Express :: 4.2.3 Bug - Cascading Style Sheets Cannot Edit From List View
Oct 3, 2013APEX Builder page 4000:37 List view shows name, notes and download columns. The name column should link through to CSS Edit page (39), but instead downloads the file. Workaround: Switch to the icon view, and click on the icon which takes you to the CSS edit page. Can the APEX team correct this, as switching to icon view is not intuitive.
View 0 Replies View RelatedApplication Express :: Page Input Item Label Conditional Style At Run Time
Feb 6, 2013We have an issue after migrating to apex 4.2.1. We have a select list and use another couple of dummy items to be used as its label instead of giving the text value to the LABEL control. Only one of the dummy items is shown as a label for the select list conditionally based on another value. It was working fine with the earlier versions upto 4.1, but with the introduction of grid in 4.2, its now displaying the select list on a new row (ie the lable in one row and the select list on the next row).
However, we really would like to solve this by having a way to display the label of the select list either in "required format style" or as an "optional style". The display style should be determined only at runtime.
Example. Say P100_MY_SELECT_LIST is the select list
The label for this item is "My Select List Label"
I have another dummy item P100_DUMMY
if P100_dummy = 1 then the label "My Select List Label" should be displayed in red and with an * *My Select List LabelOtherwise it should be in black and without * My Select List Label.
Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table
Dec 25, 2011when 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 RelatedForms :: Get Data From Ref Cursor On Oracle Forms?
Mar 14, 2012How can i get data from Ref cursor on Oracle forms?
View 1 Replies View RelatedForms :: How To Change Forms Trigger Sequence
Feb 11, 2010is it possible to change the forms trigger sequence.
for example, i am writing 'when_validate_item' in item level,block level,form level.First item level will fires and then block level and at last form level. But i want to fire the trigger first at form level then block level and at last item level.
Forms :: Cursor Move In Next Row
Oct 1, 2010i have a form and i have just one field on it and it's item_type is "List Item" and list style is "Poplist"...
my requirement is , when i press tab then i want that my cursor move in next row.
Forms :: How To Change The Name In Run Time
Jul 20, 2010I would like the change the name in run time find the attachment.
View 3 Replies View RelatedForms :: Change FMX File In Use
Jun 14, 2012I'm in an environment with Weblogic Oracle Forms 11G (Oracle Fusion Middleware). I can not update a form that is in use. I can not change the fmx file.
Can I change this? Where can I configure this?
Forms :: 4.5 - Change Value Of One Of The Field
May 24, 2010I have been asked to support an application which was developed in Forms 4.5. I have experience in Oracle database but I'm almost zero in any front end development.
As a first task I have been asked to remove a couple of field from one of the screen and then change the value of one of the field.
Forms :: Make Cursor At The Item
Jan 25, 2013I 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
Forms :: Fetch Data Through The Cursor?
Aug 22, 2010I want to fetch the data through the cursor and cursor is getting the value of group_code through the variable 'a'. but when i am writing the code like this it is not coming.
My code is like this :
declare
a varchar2(400):='';
cursor c1 is select ref_no,ref_code,company_id from stock_detail where company_id=:global.company_id
[Code]....
Forms :: Navigating With Mouse Cursor
Jan 16, 2013i am migrating from forms 6i to forms 10g but i am facing a problem. when i enter to my new form and i try to navigate thru the items with my mouse the validation of the item doesn't work properly. the cursor change position but the functionality works like it is still in the first item. the validation work when you use enter or tab.the same thing when you try to fetch the LOV, the LOV of the first item is populated not where the cursor is positioned.
View 3 Replies View RelatedForms :: How To Join Tables In A Cursor
Feb 14, 2012I'd like to join tables in a cursor.
I tried coding this way...
CURSOR studgrade_cur IS
SELECT g.stud_id, g.grade, subj_code, s.description
FROM studgrades g JOIN subjects s
ON(g.subj_code = s.subj_code)
WHERE stud_id = :Studentprofile.student_id;
but i got an error, saying:
Quote:encountered the symbol JOIN when expecting one of the following:
,; for group having intersect minus order start union where
connect
Is it not allowed to use JOIN statement in a cursor?
Forms :: Delete A Record In A Cursor
Mar 3, 2012this is just the continuation of my previous topic,
After I bound data into the textboxes, now I want to delete it when I mistakenly click on the same data twice.
this is my screenshot:
Forms :: Updating A Record In A Cursor?
Mar 3, 2012when I updated a record in my form check my screenshot: and clicked save button the result was:
as you can see in the message at the bottom, it has 18 records. And since my original data(subjects) are just 9. And also the grades that I input didn't display all.
This is my code in when-new-block-instance trigger:
DECLARE
CURSOR studgrade_cur IS
SELECT e.student_id, s.subject_code --, g.grade
[code]...
Forms :: Update Table With Cursor
Oct 5, 2010I have made changes in my form
1st step:-
for Inserting records created below cursor, records are inserted and I can see on my screen (form) also.
DECLARE
CURSOR InvestIS
select * from Tempinvest;
BEGIN
OPEN Invest;
GO_BLOCK('ReturnReport');
last_record;
[code]......
2nd step:-
Updating records
I wan to update some columns in this table so I created a 2nd cursor to update records but this cursor is not working accordingly. my requirement is: before Update first of all Find inv_co_code & inv_fnd_code when find then update column Redunits
2nd Cursor
DECLARE
ddate date; refdate date; co_code number; co_name varchar2(50); fnd_code number; fnd_name varchar2(50); units number; amount number; stat varchar2(1);
CURSOR bnr IS
select Ddate,refdate,co_code,co_name,fnd_code,fnd_name,units,amount,stat from (
select inv_date DDate,Vdate RefDate,inv_co_code Co_code,inv_co_name Co_name,inv_fnd_code Fnd_code,inv_fnd_name Fnd_name,
inv_nofu Units,inv_amount Amount,Status Stat from (
------------- Bonus -------------------
select inv_date,vdate,inv_co_code,inv_co_name,inv_fnd_code,inv_fnd_name,inv_nofu,Inv_amount,inv_uprice,'B' Status from investment
where code is null and inv_date <= :dd1
---------------- Redemption --------------
Union All
select red_date,null,red_co_code,red_co_name,red_fnd_code,red_fnd_name,red_nofu,red_amount,red_uprice,'R' Status from redemption
where red_date <= :dd1
))
where co_code = 13 and fnd_code = 1
order by co_code,fnd_code,ddate ;
------------------------------------------
vddateddate%type;
vrefdate refdate%type;
vco_codeco_code%type;
vco_nameco_name%type;
[code].......
Forms :: Invalid Cursor Using SYS_REFCURSOR
Apr 25, 2012i have created a procedure to open a query using a reference sys_refcursor as output parameter. i referenced the cursor in a pl/sql and is working correctly. however it throws error "ORA-01001: invalid cursor ORA-01403: no data found" when use on the oracle forms builder.
create or replace procedure mrch.prc_proj_list (p_add_clause in varchar2, p_rec_set out sys_refcursor) as
begin
Open p_rec_set for
'Select mp2.REGION region, '||
' mp2.ID proj_id, '||
' mppm2.PHASE phase, '||
' mm2.muni muni_id, '||
' mm2.MUNINAME muni_name, '||
' nvl((select Sum(ma.AMOUNT) From MRCH.MRC_AGREEMENT ma '||
' Where ma.PROJECT_ID = mp2.ID '||
' And ma.PHASE = mppm2.phase '||
' And ma.MUNI = mm2.MUNI),0) agreement, '||
' nvl((Select Sum(NVL(ma.GREEN_BOOK_AMOUNT,0) + NVL(ma.GB_ADJUST,0)) From MRCH.MRC_ALLOCATION ma '||
[code]....
Forms :: How To Move Cursor To Another Item
May 7, 2010I have a multi-record block like amount and date columns, its not able to move the cursor to another column if pressing enter button,(eg: amount column to date column), i have given 'NEXT_ITEM' in that field too, but oops not working
other columns cursor navigation is OK.
Forms :: Fetching Value From Dynamic Cursor?
Dec 13, 2011I have used a dynamic cursor for fetching value from different tables hence table name assigned dynamically during run time but i face an error ORA-06562 type of argument must match type of column and bind variable with error ORA-06212 But i frequently check the table structure and Declared variable there is no mismatch between them.
Code----------
Declare
C_YEAR number(38);
C_LOC VARCHAR2(200);
C_INVNO VARCHAR2(200);
C_INVDT DATE;
C_CTRT VARCHAR2(200);
C_GLCD VARCHAR2(200);
[code]....
Forms :: Update Particular Employee Name By Using Cursor
Jul 14, 2013I would like to update the particular employee name by using the cursor ..For that I would like to show the steps which I did . as in the below screen it updated John but it removed the other ename ...I like to update John only and remaining ename should be as it ..
The code which I have written on KEY-COMMIT is below.
Forms :: Placing The Cursor In The Textfield
Jun 18, 2011I am working with forms 6i version in which i developing a entry screen the first two fields are date and number which are having default values like current date and auto number respectively, my query is when new form instance the cursor should always in the third text filed shown in the attached picture.
View 1 Replies View RelatedForms :: Change Image In Runtime?
Nov 10, 2011how can change image through runtime i mean if have 5 pictures first image will showing and second image showing
View 1 Replies View RelatedForms :: Can Change The Order Of Triggers In 6i
Dec 12, 2012can change the order of triggers in forms 6i . that means firing in form level?
View 4 Replies View Related