Forms :: Setting Mouse Position And Restricting Checkbox Update?
Aug 9, 2010
what name is used to reverence the mouse cursor in Forms. I am trying to state that if the user reaches the last record in a file and clicks the mouse on the empty record below that they will get a message saying they are at the last record (basically so it means they have to manually click an add record button before they can add a new record)
I currently have this:
IF :SYSTEM.LAST_RECORD = 'TRUE'
THEN
<something here> := :SYSTEM.LAST_RECORD;
MESSAGE('You are at the last record.');
ELSE
DOWN;
END IF;
Where i have <something here> is where i assume the refence for the mouse cursor should go, of which i dont know the name, am i correct?
Another thing is that I have a checkbox that is originally NO but when set to YES cannot be turned back to NO.
I have accomplished this by putting the following code in the WHEN_CHECKBOX_CHANGED trigger and it works fine. However it also updates the checkbox to NO and then back to YES, , as a result this brings up my Are you sure you want to update message. I originally thought that if i took out the :in_active := 'Y'; the FORM_TRIGGER_FAILURE would stop the checkbox being changed in the first place but this didnt appear to be the case. how to accomplish this without letting it update at all (perhaps put something in the WHEN_VALIDATE trigger?
DECLARE
return_alert number;
BEGIN
if :in_active = 'N' THEN
return_alert := SHOW_ALERT('checkbox_alert');
:in_active := 'Y';
RAISE FORM_TRIGGER_FAILURE;
END if;
END;
View 5 Replies
ADVERTISEMENT
May 3, 2013
I have a table where i need to update one field values based on another field of the same table , simply as it is.I have done this using one select all check box , on clicking that all check boxes of item_trans table will get selected , then i will un select some of check box and then using one button, i will update the value of the fields which are checked only.
I have put the sample code but when i am updating its taking long time and hanging.I am also attaching the form based on the test case provided.
--tables with insert statement
create table item_trans (trans_item varchar2(12),trans_qty number,trans_act_qty number)
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE1',40,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE2',20,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE3',20,NULL);
--i want to set the value of trans_Act_qty as trans_qty
--i create one dummy or test block to keep the select all check box. for that table test script is
CREATE TABLE TEST
(
C VARCHAR2(2000 BYTE),
B NUMBER,
A NUMBER
);
insert into test (C,B,A) values ('A',1,1);
--code written in select all check box which is created on test.block.
BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
:M_END_YN := :M_END_ALL;
[code].......
--code written in M_END_YN ( actual check boxes where i will uncheck).
IF :M_END_YN = 'N' THEN
:M_END_ALL := 'N';
END IF;
--code written on button to update those values which are checked.
BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
IF :M_END_YN = 'Y' THEN
[code]......
View 5 Replies
View Related
Sep 5, 2010
why when-mouse move,up,enter,leave are not working in oracle forms 10g except when-mouse-click and when-mouse-doubleclick on any items.
what i need to do to execute this triggers..
View 3 Replies
View Related
Jan 16, 2013
i 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 Related
Jan 28, 2010
i am working on attendance system using barcode scanner.
i want the user can only mark his/her attendance by scanning the attendance card.and cannot use keyboard.
View 9 Replies
View Related
Apr 11, 2011
I am using the below code to disable forms field in fdtlblk.mdt_rqr = 'NO'
but I can go there with mouse click ( for tab and enter it is working fine ) .
but for mouse click it is not working .
if (:fdtlblk.mdt_rqr = 'NO') then
go_item('fdtlblk.section_loss');
set_item_property('FUP_RCVD_DT',enabled,property_false);
[Code]....
View 1 Replies
View Related
May 27, 2011
I created TREE object in my application main menu and I want to use it through MOUSE and KEYBOARD therefore I add WHEN-TREE-NODE-ACTIVATED trigger at my tree object
Trigger text is:
declare
htree item;
node_value VARCHAR2(100);
akt_node ftree.node;
[code]...
Problem:When I am using MOUSE and clicking on + or anyother form/report, it's opened last selected form/report or application closed but it is working fine when I am using KEYBOARD.
View 1 Replies
View Related
Jun 9, 2013
I want to link to blocks using description as there is no relation , for example i have two tables with one field in common called description, and i want to link this field in two tables using like operator.
create table item ( item_code varchar2(12),item_name varchar2(30));
insert into item VALUES('A','HEA160');
insert into item VALUES('B','HEA180');
create table stk (sl_item varchar2(12),sl_desc varchar2(30),sl_qty number);
insert into stk VALUES ('X','HEA160X1000',12);
insert into stk VALUES ('X','HEA160X2000',4);
insert into stk VALUES ('Y','HEA180X3000',10);
Suppose i click on item block item_desc with value on HEA160 all the items similar to that should appear in stk block like 'HEA160X1000' ,'HEA160X2000' , if i click on 'HEA180' on item then 'HEA180X3000' it should come.
View 1 Replies
View Related
May 6, 2013
I would like to know if with Oracle Forms Builder 11g, we can use mouse instead of TAB to validate record? And why Forms Builder use TAB or ENTER Key to validate record? I have a SAVE button, but i want to replace the TAB navigation validation by the mouse click. Is it possible?
View 6 Replies
View Related
Sep 29, 2012
My development instance's APEx version is 4.1. I have two checkbox items works on cascading LOV. The cascading works very well as long as if I do not come back and check anything from the first checkbox item after I checked the second checkbox.
If I do, the cascade LOV refresh uncheck all checked values from the second box. My question is, how can I preserve the second check boxes checked values before refresh?
View 0 Replies
View Related
Mar 2, 2010
I created Main Menu form and in this form I attached popup menu in picture's property problem is that when i right click on this picture then show the popup menu .I want when I click left click then it should show the popup menu.
View 2 Replies
View Related
Apr 5, 2010
I m using oracle forms 9i in which i want effect on text fields that will change color of text after mouse cursor move on that field . is it possible in oracle form 9i .
View 6 Replies
View Related
Jul 15, 2011
I am trying to disable mouse navigation on data block or text item,. What i want is to my text items in specified block be keyboard navigable only.
The problem is that i don't have that option on text_items or data block (my conclusion: probably because it is not possible to change mouse navigate option for text item or data block).
I have also tried in WHEN-NEW-BLOCK-INSTANCE trigger
set_item_property('block.item', mouse_navigate, property_false)
and
set_block_property('block', mouse_navigate, property_false)
and of course it did not work.
View 5 Replies
View Related
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
Aug 1, 2011
I have included a calender control in my form and its working fine.Now, my problem is how can I automatically place the calender next to the text-item (for example, "block.invdate")if the push button is pressed to call a calender.
View 1 Replies
View Related
May 25, 2011
SQLserver in stop condition when i play it. it again stop
View 1 Replies
View Related
Feb 25, 2010
I want to get current mouse cursor position dynamically,what should i do.
View 3 Replies
View Related
Jan 22, 2013
I am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?
Yes No Cancel.
Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.
View 1 Replies
View Related
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
Sep 30, 2013
I need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies
View Related
Aug 26, 2011
i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example
if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd
View 4 Replies
View Related
Nov 4, 2010
I am using oracle form builder 6i and oracle database 10g
1:I have table named 'info' column name 'InfoId'and some other.And another table named 'Handing' with column names HtId, Value1 and value2.
2:I made form that consist of three data blocks, first block takes criteria and second block display record against that criteria from table 'info'.
3:i want checkboxes agianst that display record,and want that when I select some checkboxes against 'InfoId' these selected 'InfoIds'
should save in another table named 'handing' in column 'HtId'.and in same table data in column value1 and value2 will be inserted through textboxes that are in the third datablock of the thae same form .
View 2 Replies
View Related
Jun 17, 2013
I am Using the Check Box in the Detailed Block & I Have Assigned values 'Y' and 'N' when Checked & Unchecked If there are 3 Values Retrieved in the Detailed Block, Among that 2 Values are Checked the Cursor is Directly going the 2nd Value and Displaying the 2nd Value 2 Times rather than Displaying the 1st Value.
Below Attached is the Code Which i am Using.
GO_BLOCK ('ITEM_RESULT');
L_ITEM_CODE := :ITEM_RESULT.ITEM_CODE;--71720;--
first_record;
loop
message (' item id is '|| L_ITEM_CODE || '-' || :ITEM_RESULT.CHECKBOX);
if L_ITEM_CODE is not null and :ITEM_RESULT.CHECKBOX = 'Y' then
begin
[code]....
View 6 Replies
View Related
Aug 3, 2011
I was working with forms and found a problem related to accessing of status of checkbox. In a block with multi record to be checked, if we want to check all the checkbox status which is already clicked, Then what should i do.
Now i am using the function Checkbox_check as:
if Checkbox_Checked('FVA.STATUS')
But the problem with this function, it is giving status of last clicked checkbox only.
View 17 Replies
View Related
Oct 28, 2010
I have a data block which contain no. of records displayed e.g 10 record...In That data block i used checkbox
My Requirement is when i click Select all checkbox , No. of checkbox record shown click mark..how to do that.
View 3 Replies
View Related
Aug 2, 2012
I have a custom form build on Oracle Forms Builder 6i. It is divided into tow tabs I have to place a checkbox on tab 1 and control the values of a column present on tab2. When the checkbox is ticked the values in column should be 'X' and if the checkbox in unchecked all the values should be changed to 'Y'.
View 3 Replies
View Related
Oct 17, 2008
I have a multi row datablock with scroll bar. In each record I have a checkbox (let's call it check_record), and above these checkboxes, there is a checkbox to check/uncheck all the checkboxes (let's call it check_all).
If all the "check_record" are checked, the "check_all" must be automatically checked, else if one "check_record" is not checked, it will be unchecked.
To do that, I have put a loop in the WHEN-CHECKBOX-CHANGED of "check_record" to loop over all the "check_record" and see if they are checked or not.
Normally, this loop will automatically go to last record. But to go back to the selected record (where the "check_record" was clicked), I have used go_record with the record ID.
==> No problem in that, it's working fine.
Now, this is my problem: When clicking on a "check_record", the scroll bar moves to show the selected row in the first (or last) VISIBLE row in the data block, and that's because of using "GO_RECORD(<CURRENT_RECORD>)".
Example: if I select the third record in the data block, the scroll bar moves to show it in the first visible row.
Is there a way to "freeze" the scroll bar and keep the record in its initial position in the data block?
View 7 Replies
View Related
Jun 25, 2013
I have created a custom form which fetches certain records. There is a column called invoice_create_flag which is check box. By default when we query this form, value of check box is 'Y'. Another column is Amount.
Initially when form is called, all the records are selected. Hence it should show the total of all the records. Now If the users unchecks any record, System should deduct the amount of that particular record from the total amount.
Attached is form screenshot for reference.
View 1 Replies
View Related
Jun 10, 2011
I am using oracle forms 9i. I have to create a Hierarchical Tree and attach checkbox at its node,so that user can select which tree he want in its further processing.
View 4 Replies
View Related
Aug 1, 2012
My requirement is I have placed a check Box in the Detailed Block and i have assigned values for the check box as
Checked - R
Unchecked - P
Initial Value - R
by default the check box would be displayed as Checked while inserting the values in to table the value of check box is not getting inserted but when the check box is unchecked the the value is getting inserted as P when the submit button is pressed.
View 11 Replies
View Related