Forms :: Records Not Displaying In Specific Text Item

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


ADVERTISEMENT

Displaying Records Between Specific Times On Specific Dates?

Apr 11, 2011

I have a database which consists of various orders and various field.

I have a variable called createddatetime . I want that whenever i should run the database it should display records from

Yesterday 06:00:00 am to Current Date 05:59:59 am

Now to implement this i tried to put this syntax

and to_char(Createddatetime,'dd/mm/yyyy HH24:mi:ss') between 'sysdate-1 06:00:00' and 'sysdate 05:59:59'

But nothing comes up

where as definitely there are records between times because when i do and Createddatetime between sysdate-1 and sysdate I see valid records coming up.

View 3 Replies View Related

Forms :: How To Show Total Number Of Records In Text Item

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

Forms :: Is There Text Changed Trigger With Text Item Function

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

Forms :: MS Word Rich Text Format In Text Item

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

Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item

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

Forms :: Developer 9i AS Using Specific Item

Apr 15, 2010

I develop a form using Devloper9i AS, oracle 9i, Winxp

I need to use items like "ActiveX Control, OLE Container, Sound " but they are marked as obsolete by Developer9i AS;

so how can I use like this type of items when I establish a form design ".fmb" .

View 2 Replies View Related

Forms :: After Post Trigger Go To The Specific Item?

Feb 8, 2013

I have this layout

[URL]

and a post trigger insert and update

IF :item1 IS NULL
AND :item3 IS NOT NULL THEN
alert_id := FIND_ALERT('blank_alert');
SET_ALERT_PROPERTY(alert_id,ALERT_MESSAGE_TEXT,'Item3 must have a value.');
v_alert := SHOW_ALERT(alert_id);
RAISE Form_trigger_Failure;
END IF;

My problem was as it fires, the cursor will be on the item1. I've already use

SET_ITEM_INSTANCE_PROPERTY
NEXT_ITEM
GO_ITEM

but it was all illegal. The cursor must be in the item3.

Don't question me why I do not set the item3 to required and why post triggers. It is just that. It is the requirement.

View 4 Replies View Related

Forms :: Displaying Number Of Records With Condition

Jul 8, 2012

In form i call a record from database table through execute_query. i have lov on ITEM_NO

i want to display on that form, no. of records of ITEM_NO which i select from the list. like if i have 10 records with item_no which i select from list is must show 1/10.

if i press the down arrow it should show next record of the same item_no.

View 5 Replies View Related

Forms :: Displaying Records From A Table In Tabular Form With One Condition?

Mar 17, 2012

i want to display records from a table in tabular form with one condition.

i made a tabular form.and in WHEN-NEW-FORM-INSTANCE i write

DECLARE
CURSOR hascr IS
SELECT
BILL_ID,
BILL_DATE,
MAT_CODE,
PLACE_FROM,

[code]....

when i run the form its not showing any errors but displaying only one record.that is the first record whose bill_type is send to other store.

am i using the right trigger or my select statement has problem?

View 9 Replies View Related

Forms :: Verification Of Item Text?

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

Forms :: How To Set Text Item Transparent In 6i

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

Forms :: Pre-text-item Trigger?

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

Forms :: Key Press In Text Item

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

Forms :: Clearing The Text Item

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

Forms :: Filling A TEXT-ITEM?

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

Displaying Specific Data From Database

Apr 5, 2008

i have columns called data_received(data received from server) , URL (sites visited)

now i want to display top 50 sites based on highest data_received.URL column will have some sites repeated.

View 1 Replies View Related

Forms :: A Text Item Key Stroke Interceptor

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

Forms :: Text Item Content Disappear

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

Forms :: Blinking Text Item In Oracle 6i

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

Forms :: Dummy Background Text In Item?

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

Forms :: Changing LOV Based On Some Other Text Item?

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

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 View Related

Forms :: Changing Text In A Display Item

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

Forms :: Font Space For Text Item Is Not Working

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

Forms :: Change Color Of Text Item Using Timers

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

Forms :: Text Item With Long Data Type?

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

Forms :: How To Set The Background As Transparent Colour For Text Item

Jan 20, 2010

I want to set the backround colour of text item as transperant with Form colour.

View 1 Replies View Related

Forms :: Written English Characters Only In Text Item

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

Forms :: Get Chosen Value In Radio Button Into Text Item Which Is In Another Form?

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







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