I'm new with javabean I find this website URL.....
most of this examples use this built-in Set_Custom_Property..i need you to provide with syntax and the full list of property in this built-in
all or most of the examples there is (1) in second parameter what is this (1)
What is the uses of "Validate From List" Property(Yes/No) in LOV's Properties.
View 3 Replies View Relatedthis from has multirecords and multiblocks for every date it shows employees' attendance record, there is a button that should disable selected records for that specific date
**part from the code**
LOOP
if :ATTENDANCE.SIGGNED = 'Y' AND GET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',STATUS) = 'CHANGED' THEN
:ATTENDANCE.LAST_UPDATED_BY:=fnd_global.user_id;
:ATTENDANCE.LAST_UPDATE_DATE:=sysdate;
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',ENABLED,PROPERTY_FALSE);
[Code]...
what happen that it is confirming that selected records are disabled AND it is NOT!!
**i can still change the records if i want **
but if I changed the date and go back "the date which i disabled its records" (reload that data) then it will be disabled
finding a way so it will be disabled immediately so i don't need to change dates to be disabled
**maybe if there is a code that will refresh records ?!
The code on menu item is UnVisible_Menuitem('ITEM193');
Menu procedure is
PROCEDURE UnVisible_Menuitem( menuitem_name VARCHAR2) IS
mi_id MenuItem;
ALT NUMBER;
BEGIN
mi_id := Find_Menu_Item( menuitem_name );
[code]...
i try it for the both visible and non-visible items but it dosnt work.
I am using Forms 6i in Oracle Applications, In the button click event i used set_canvas_proeprty() twice. First time it executes these two statements, second time it does not. If i use any message() statement before these two statements, it executes.
Do we have wait() statement in Forms ?in apps we have app_item_property.set_property(), can we use same command to set canvas property also.
i am running oracle 10g developer release2. i want to set item property false/true in response to a specific action, like disabling text item when check box or radio button pressed.
View 1 Replies View RelatedIs it possible to change the item_type property of an item at runtime.
I have one text item and i need to lock(Read only) that item. I hope we can change the ENABLED property or by changing the ITEM_TYPE as DISPLAY_ITEM.
How to change the Item_Type to DISPLAY_ITEM from TEXT_ITEM at run time or else is there any other way except ENABLED property to male the field as READONLY.
Can i change the property of item dynamically in pl sql coding. Actually i want that whenever the user press some button then that field(textbox) become non-database item of the database block. put some value in it and press another button to restore its property like before.
View 10 Replies View Relatedjust i want to ask about access key property for button..i'm using oracle forms 10g ,
suppose that i have 3 buttons in a module like the following:
1- buttonOne --access key property for this button is "1"
2- buttonTwo --access key property for this button is "2"
3- buttonThree --access key property for this button is "3"
when run this module then the user press "1" the trigger when-button-pressed not fire until he press Alt+1...how the user can press the "1" only to fire the trigger when-button-pressed? just like form 6i?
frm-41375: cannot set queryable property of calculated item :emp.sumsal.
View 8 Replies View RelatedOur application is using GET_APPLICATION_PROPERTY to retrieve user name, password and connect string. Since we have started using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production the problem started with password case sensitivity. The function returns uppercase password whereas if the user has lower or mix case password they mismatch.
View 6 Replies View RelatedI want to change Database Data Block Property at runtime.
View 4 Replies View RelatedI 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);
I want to change the current visual attribute color of my form at the application level, reason being i don't want to generate all the forms again from scratch.I know that we can change this using visual attributes but is there a way to change this through some form setting?(Oracle 10g)
View 3 Replies View Relatedi have a block of multiple records where the user can edit the shipment totals of products being sent to branches.
some branches can't receive certain products and usually we just default the shipment value to zero but the user can still edit that value.
What i want to do is iterate through that block and check the branch and product and set the update property to false for only that record. is that possible.
i have a form having 4 database data blocks and one non database data block(for Push Buttons like SAVE,CLEAR,EXIT..).
In the control Block i have 5 push buttons out of which one is used to Save the entries and one to clear the form. In the coding of SAVE button after writing "COMMIT_FORM;" i want to disable all other Data block on my form excluding the one containing Push buttons so that the data entered by end user stay appearing on the form till he Clears the form.
Now the problem is that when i set enabled property of one particular text_item to false , the form if closing down along with the application, it is totally disappearing from screen.This is happening for one particular text item.
what could be the possible reason for this and what needs to be done to overcome this problem.
I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".
I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.
DECLARE
CURSOR GRP IS
SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc AName,Letter_Group_ID
FROM Hrs_Group;
BEGIN
Clear_list('Letter_Group_ID');
FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
END;
FRM-30351: No list elements defined for list item.
List LETTER_GROUP_ID
I'm using Sqlquery doing the following query:
context.Database.SqlQuery<table>(@"select * from table Where id=2").ToList();
My table "id" column is decimal(10) and is treated as int32 by default in edmx, in my "table" entity the "id" property is also of type int.but while executing this query, it throws an error:
"id" property of“table”cannot be set to "Int64". It must be set to a not null value of type “Int32”.
I wanna know what is wrong here, why I'm getting such "int64" error?
we are currently migrating from forms 6i to 11g. We would like to cleanup our global variables at runtime.
Is there any way to list the global variables at runtime?
how to set connection property "oracle.jdbc.thinLogonCapability"
View 3 Replies View RelatedI have developed one sample form using oracle Internet developer Suite 10g. It has two fields.
1.all employees(I set as combobox)
2.members (i set as text box)
In runtime all employees column has all the employee name displayed . If i select the employee name one by one it added into the members textbox. How to solve that issue?
I have a non-database text item (name: profession_temp) on a block and it is a also return item for an lov.
When I change the property "validate from list" of the item(name: profession_temp), to YES, and closing the form without inserting, updating, deleting any record , a message is displayed "do you want to save the changes?".
When I change the above property back to "No", the message is not displayed in this case. I wonder why this message appears while there is no change occurred in the underlying records?
View the attached form image.
There are two List boxes namely :list_all (All) and :list_sel(Selected). :list_all show some data. What I want is to insert / delete records from the list_all to list_sel or vice versa using the buttons ( e.g.For one record using > and for all >>). The next step is to call a report to show data from the :list_sel.
I have populated the list_all with using the following query.
"select distinct all_ded,to_char(all_ded_id) from salary_temp order by all_ded"
Forms:6i
Database: Oracle9i
Im trying to list the products list of a client grouped by type of the product. Ex:
product type
prod.A acid
prod.B flavour
prod.C acid
prod.D cleaner
prod.E flavour
I want to list something as:
Acid
Prod.A
Prod.C
Cleaner
prod.D
Flavour
prod.B
prod.E
I have a list block of two fields item_name, item_price. User can enter as many item`s as she/he wants. But, before saving the record system should calculate the total and give error if sum is grater then or less than 100.
View 2 Replies View Relatedi have a parameter form where user will input from item to item and items within this range will be come as output , but i want an option to select the random items from the list, like i may not select all the items from 1 to 10 , but instead i want to pick or select randomly , i may opt for 1,3,4 and 7.
View 4 Replies View RelatedI am working on form 6i..
I have developed a form with some text items,a list item and a image item...
list item......account_list(values....company,individual)
text_item..... company_name..
text_item.....image_path...
i have attached a pop up menu to image item... Add image and upload image...
When i click on 'Add image' the image path is getting enabled.. it is fine but when i am changing the account_list i need enable and disable the 'Company_name' text item... How can i achieve this??
I have tried it in when-validate-trigger on account_list...
if account_list=individual then
set_item_property('company_name',enabled,property_false);
else
set_item_property('company_name',enabled,property_true);
end if;
But no use of this....
how can i achieve it??
i want to create the list item dynamically on the when new form instance this is the code....
group_id := create_group_from_query('lst','select (imt.item_id), to_char(imt.item_code, from items_mt imt');
v_num := Populate_group(group_id);
populate_list(v_num,group_id);
but the list is not the populate.
how to create dynamic list item ????
View 5 Replies View Related