Forms :: Checking To See If A Text Item Is Empty
Aug 8, 2010
I was wondering can i check if a text item in another block is empty when a user try to create a record using a button in another block.
/*creating a program that will check to see if the customer id in the customer block is null it will then display the the stop alert and tell the user that he/she cant create a new order without having a selected a customer*/
--this is the block_item im checking to see if it null
IF (:customer.c_id) = NULL THEN
DISPLAY_ORD_STOP_ALERT;
GO_ITEM('CUSTOMER.C_ID');
[code]....
View 5 Replies
ADVERTISEMENT
Sep 24, 2010
I am select list of ids;
cursor c1 is
select c_id from ctab1 where login = l_id
union
select c_id from ctab2 where login = i_id;
now I need to return err_code and err_message if this combined list is empty ! Can not use exit%notfound.
View 5 Replies
View Related
May 5, 2010
Is there text changed trigger with text item function like when_list_changed trigger of list item?
View 7 Replies
View Related
Apr 17, 2012
Can I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.
I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.
View 3 Replies
View Related
May 22, 2010
I have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
View 1 Replies
View Related
Mar 19, 2013
I want to make a verification of an item text ,the user must enter a number of length 4. So I created a text item :number(4). and in when-validate-item trigger of this item ,I put this
if length(:block.empno) != 4 then
message('this item must containonly 4 digit');
end if;
=> the problem, when the user entered "0123" ,it should be acceptable !! but this is not the case ...
View 12 Replies
View Related
Dec 21, 2011
I am having Forms with background image on the canvas. now my problem is, how can i set a text item to be transparent so that the background image can be seen as clear as when there is no text item on it.
View 6 Replies
View Related
Nov 17, 2008
In my form, for an item there is code for pre-text-item trigger. In query mode when i go to next record, previous record etc, whether this trigger gets fired? In other forms it is getting executed. Only in this form it is not getting executed. What should be reason for not executing this pre-text-item? Only this item is enabled and cursor is there.
View 9 Replies
View Related
Oct 9, 2010
A form with two text fields text1 and text2. Now i want to enter text value in the text1 field and subsequently this value entered into text2. i.e if i want to press x in text1 it also in the text2. if i want to press y in text1 it also in the text2. and so on without using enter key.
View 3 Replies
View Related
Jun 26, 2013
I am working on oracle form to build a login page and i have successfully completed it. But to make it more perfect i want to clear the text_item in which the username and password is entered. i have even raised the alert as well but after closing the alert i want to clear the text item .
View 3 Replies
View Related
Jun 21, 2010
I`m new with Oracle Forms. I have the following trigger WHEN-BUTTON-PRESSED :
DECLARE
BEGIN
IF :SEARCH.SBOX is not null then -- (search text item)
IF :SEARCH.LIST45 = 'ERPLINK' THEN --(a drop down list)
[code]...
What do I want is the following thing :I have a text box :SEARCH.SBOX in which I write a number.When I press the button which will execute that trigger above, I want that the value from :SEARCH.SBOX, after the form will go to enter-query mode tofill up another text_item :CUSTOMERVIEW.ERPLINK with same value and execute_query(this text item is in master-detail form).
View 3 Replies
View Related
Mar 13, 2010
Like vb 6.0 or vb.net in textbox's change trigger fires...when we start typing in the text boxes instantly. i want exactly this feature in forms how to do this.
I also got answer from some-body that it can be achieved by using java beans. i want the procedure of doing this or the sample
.fmb file and .jar file.
View 3 Replies
View Related
Mar 11, 2010
I have data Block with many Items, text item content disappear after when mouse down trigger fire on text item in the same block!!!!!!!!!
View 1 Replies
View Related
Sep 3, 2013
I have one database text field in oracle forms 6i and its color will change dynamically by using visual attribute.But actual my requirement to blink this text field by red color when value matches.
View 1 Replies
View Related
Jul 3, 2012
i want to display dummy background text in one of the item of data block. is it possible is forms 10g.
for ex: i have lov on one item with WHEN MOUSE CLICK trigger.when u click mouse in that item lov popups.
so for user to understand is just want to display dummy text as CLICK HERE FOR LIST in item's background or something like disable text.
View 3 Replies
View Related
Apr 18, 2013
I got a required to show LOV or list ... based on some value in other column. suppose in column A has value is A1 then column B should show A11, A12 , A13 and if Column A has value C then cloumn B should show C11, C12 ... etc//
View 2 Replies
View Related
Dec 20, 2010
I have text in a display item on my Oracle Form. When my user hovers over the text with my mouse I want it to show my user that the text is active. The text may change color(no tool tip).
Is this possible?
Environment: Client / Server
View 3 Replies
View Related
Mar 9, 2013
I have one text item where i inserted some text . i want to change at run time the text space by using Font_spacing property . This thing is happen by using a push button(trigger when button pressed ). but after clicking the button this is not working.
View 1 Replies
View Related
Feb 23, 2010
How can I change the color of a text item in Oracle forms using timer for every 500 milliseconds? The text must appear to be blinking.
View 3 Replies
View Related
Sep 6, 2011
I have a form with an item with "datatype=long". when I am typing in "Arabic" or "Persian" it break the text before line ends.but when I type in English "text" go to end line(in other words line fills to the end) and then breake to next line.It show that the problem is LANGUAGE.
nls_lang=AMERICAN_AMERICA.ar8mswin1256
Regional and language/regional option=Arabic(U.A.E)
in the block/item property : wrap_style= word ----multi_line=yes
View 2 Replies
View Related
Feb 14, 2012
I have for example two text items(number of records to display is set to 9). What I want is when i go to studentprofile block, it should automatically shows his subjects that are already taken up. the first text item is for 1st semester subjects and the other for 2nd semester.
here is the structure of my subjsec table:
ID number(1)
subj_code varchar2(10)
day varchar2(10)
and for subjects table:
subj_code varchar2(10)
description varchar2(50)
units number(1)
semester varchar2(10)
I restricted subjects that are in 1st sem. So i did something like this in my
DECLARE
CURSOR studgrade_cur IS
SELECT g.stud_id, g.grade, g.subj_code, s.description, s.units, s.semester
FROM studgrades g , subjects s
WHERE g.subj_code = s.subj_code
AND g.stud_id = :Studentprofile.student_id;
[Code]....
View 32 Replies
View Related
Jan 20, 2010
I want to set the backround colour of text item as transperant with Form colour.
View 1 Replies
View Related
Oct 30, 2011
I want written English characters only in text item (I want control in one text item), in my form 10 g but, in same form can be written other language in other text item.
View 1 Replies
View Related
May 3, 2013
I have a multi record field of five rows. And 3 values.
the values are
IT
CSE
ECE
And i have one text item name is COUNT.
how to show the total number of records in Text item .
View 10 Replies
View Related
Feb 25, 2013
how can i get the chosen value in radio button into text item which is in another form?
Suppose i have 3 radio buttons (watch, gadget and jewelry)then I choose watch.How can i display that chosen radio button into the text item which is in another form?
View 7 Replies
View Related
Aug 22, 2010
How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.
View 4 Replies
View Related
Mar 13, 2013
I have a multi-record block with several text items.
On one of the text items i want to enter a value and then check whether the same value for the item has already been entered on any other records within the block.
If it has already been entered then i want to display a message and null out the field.
I have tried using app_record.for_All_records from a when-validat-item trigger but this does not work as you get a 'FRM-40737 Illegal restricted procedure go_block in when-validate-item trigger ' error
View 17 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
Apr 14, 2010
I have text file with data in UNIX. I want to clear only records(make empty the file) using UTL_FILE..
I know we can remove the text file from UNIX and create file again with same name...
Is there any other way??
View 5 Replies
View Related
Sep 8, 2011
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.
View 5 Replies
View Related
