Forms :: Moving Data Between Two List Items

Dec 8, 2010

My form has two list boxes and two buttons add and remove. As and when i click add button, the selected value from left hand side list item should get populated to right hand side list item. And When I click Remove button, it should do vice versa.

View 10 Replies


ADVERTISEMENT

Forms :: Populating List Items

Jun 7, 2010

there are 3 radio buttons and 1 list item

i want different options to appear in the list item when choosing different radio buttons.

i've tried to compile the codes and there are no errors.

I dunno what went wrong.

B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME

the following is my
DECLARE

[Code]....

View 2 Replies View Related

Forms :: Dynamic List Items

Apr 21, 2011

I want to create two list items. one is for deptno and another is for empno in a single form.

Based on the selected deptno value from first list item i want to populate corresponding empno from second list item. I tried with the fallowing code, it's work fine but the second list is not clears with the existing empno's.

Code for Deptno List item

declare
cursor c is select deptno from dept;
cnt number := 1;
begin
clear_list('LI_DEPTNO');

[Code]...

Code for Empno list item in when_list_changed trigger for deptno list item

declare
cursor c is select empno from emp where deptno = :LI_DEPTNO;
cnt number := 1;
begin
it_id := Find_Item('LI_EMPNO');
clear_list(it_id);
for i in c loop
add_list_element('LI_EMPNO',cnt,i.empno,i.empno);
cnt := cnt + 1;
end loop;
end;

View 3 Replies View Related

Forms :: Multiple Items Selection In A List Item?

Jan 6, 2011

I have a requirement to select multiple values from a list item and do some manipulations with those values. I tried by integrating the LOV with a text item, but couldn't able to select multiple items. Is there a way to do multiple selection in a list item ?

View 1 Replies View Related

Forms :: How To Bind Hierarchy Tree Items To Text And Other Items

Jan 31, 2012

I have already done a hierarchy tree. Now I'd like to make it bind to text items. When i click a node, it should automatically be bound to text items.

My tree is about sections of students, now when i click a specific section to view its corresponding subjects it would be displayed on text items.

For example:

+Sections
+First Semester
+LM2
+LM3
+Second Semester
+LM4
+LM5

When i would click on LM2 node, its subjects should appear immediately.

View 1 Replies View Related

Creating List Of Items And Using Foreign Keys As Primary

May 19, 2007

How can I create a list of items in a field, for instance lets say I have a table called car and one of the sub categories is parts. How can I make it so that parts can be any number of pre-defined entities? Or even table, for instance if I make a table called parts how can I use that in the car table in place of parts?

My second question is about using foreign keys as primary keys. If I am writing an email sql DB and I decided to use the members usrname as the primary key in the member table but then made another table that lists all the emails and decided to make the foreign key member username the primary key there.

Is that safe to do or should i create a sequence in which to identify a primary key for the email list table? Also what if I extend member to several other tables and use it as a primary key there too, seems like a kind of dangerous way to do things...

View 1 Replies View Related

Forms :: How To Count Number Of Items Present In A Data Block

Aug 20, 2011

how to count how many items present in a particular data block in oracle forms 10g.whether it is a text_item or display_item or list_item etc is there any method to do this.

i have written this when-button pressed but the problem is how to get the next item name in the block

DECLARE
V_COUNT NUMBER:=0;
V_FIRSTITEM VARCHAR2(100):='';
BEGIN
GO_BLOCK('BLOCK_ITEMCOUNT');
V_FIRSTITEM := GET_BLOCK_PROPERTY('BLOCK_ITEMCOUNT', FIRST_ITEM);
LOOP

[code]....

View 3 Replies View Related

Forms :: No Data In List Item?

Mar 1, 2011

I am populating the list item from predefined record group. the form is running fine but it didnt show the data present in the record group. I have placed the following code in Pre-Form trigger.

declare
list_id item;
rg_id recordgroup;

begin

rg_id := find_group('RECORD_GROUP9');
list_id := find_item('block2.list4');
clear_list(list_id);
populate_list(list_id, rg_id);
end;

View 7 Replies View Related

Forms :: Entering Data In List Of Value

Apr 3, 2011

I have created a list of value , If I do not slect any of the values then I would like to enter data in that column .

how I can do this .

View 2 Replies View Related

Forms :: Populating Data In List Item?

Jul 15, 2005

I have created a item, CO_NAME as List Item and list style is Poplist.

I have written following code in when-new-form-instance to populate the data from table to item.

DECLARE
rg_name VARCHAR2(40) := 'COMPANY';
rg_id RecordGroup;

[Code].....

But when I run the form, Oracle Error - FRM-41337:Cannot populate the list from record group.

View 2 Replies View Related

Moving Data From Datafile

Mar 7, 2011

In my Production DB. 5 Datafiles created in same tablespace. Datafile size is of 25GB. Data stored in all Datafile. Data is just 5GB in all datafile. I want to move data from 5 datafiles to single or couple of datafiles.

This is in Oracle 11g.

View 2 Replies View Related

SQL & PL/SQL :: Moving Data To Another Table

Jan 21, 2013

I have imported data into database using sqlloader into flat table. Now I need to move the data from this table to another table. This is production system and I must keep it online. So I decided to make script that will move data in small chunks and commit frequently to avoid waits and table locks.

Regarding the script I have question. I can to the bulk load of rowids. Is it possible to optimize the insert and delete in similar way instead of doing insert/delete in loop for each rowid ?

declare
type t_rowids is table of rowid;
rowids t_rowids;
begin
loop
select rowid bulk collect into rowids from ims_old.values_f2 where rownum < 1000;

[Code]....

View 6 Replies View Related

Forms :: How To Avoid (no List Elements Defined For List Item) Error

Sep 27, 2011

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.

View 1 Replies View Related

Replication :: Moving Data From One Machine To Another?

Aug 21, 2008

Oracle Data Replication. I am using Oracle 10g release 10.1 and I want to do replication of my data from one machine to another machince.

View 2 Replies View Related

Moving Data To Encrypted Tablespace?

Dec 19, 2012

"All data you create in this tablespace will be encrypted using an AES256 encryption key. You cannot encrypt an existing tablespace. To encrypt data, first create an encrypted tablespace, then use alter table move, CTAS or datapump import to move your data into the encrypted space. Remember to drop the old tablespace BUT not including datafiles. Use an OS schred program to remove the old datafile. If you are on ASM you may use the including datafiles option since you can’t schred files from the OS inside an ASM instance."

But i want to know why we should NOT drop the including datafiles, when dropping tablespace (so 'drop tablespace my_tbs including contents and datafiles'). So what option should we use when dropping tablespace?

Why we should use OS capabilities to remove the datafiles?

What happens if i remove the datafile when i drop the tablespace?

View 13 Replies View Related

Forms :: FRM-30351 / No List Elements Defined For List Item

Oct 30, 2011

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

View 4 Replies View Related

SQL & PL/SQL :: Find All Data Items In Hierarchy Recursion?

Jan 21, 2003

I need to find all "report to" supervisors in a hierarchical chain. A binary search won't work, as each level may contain > 2 supervisors. Example:

1

2 3 4

5 6 7 8 9

10

10 reports to 9
9 reports to 4
5 and 6 report to 2
7 and 8 report to 3
2, 3 and 4 report to 1

Result for all reporting to 1 would be a table containing 2, 3, 4, 5, 6, 7, 8, 9, 10 (order is unimportant!).

I think I need to use recursion. I can do this in C; need code for PL/SQL??? (I can't get the "tree" to display well!)

View 4 Replies View Related

Import - Moving Data From 10g Enterprise Edition To 11g?

Sep 23, 2013

Am moving data from 10g enterprise edition to 11g standard edition using normal import commandafter completing i just go through the Log.i found a thing which makes me confusing

in some tables alone a row is not inserted stating the ORA-12899 while checking with the database it shows the column is varchar(100)in the log the error showing it tries to insert 101 character. how it happening to a single row

how can i solve it

View 3 Replies View Related

Forms :: How To Go Through All Items In The Form

Jul 6, 2010

is there any way or loop to go through all items in a form and check them with a condition ???

View 5 Replies View Related

Forms :: How To Add Text Items At Runtime

Dec 24, 2012

I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?

View 1 Replies View Related

Forms :: Items On Tab Page Getting Invisible?

Oct 12, 2010

when i am selecting a record from a LOV which is associated with a button on a tab page of a tabbed canvas; all the items on the tab page getting invisible. But when i navigate to another tab page and then come back to the former tab page all items reappearing.

What could possibly be the reason for this and how to restrict items from disappearing?

View 4 Replies View Related

Forms :: 6i / Validating Text Items?

Nov 24, 2010

I am working on form 6i.

i need to write validation on text fields like first name,last name,phone no,email id

i have to not allow special char.

View 3 Replies View Related

Forms :: Numeric Listbox Items?

Apr 12, 2010

I've got a colleague that is trying to populate a list box item with a group of numeric values that represent highway route numbers.

The database view defines the route as a "number".

How can we create a numeric list box? The built-in functions populate_group, and populate_list both expect to get varchar2 parameters.

View 1 Replies View Related

Forms :: Queries On Long / Lob Items?

Feb 2, 2013

how can I have queries on long/lob items in form.

View 1 Replies View Related

Forms :: Two Control Items With Dependent LOV?

Jun 28, 2011

I have created two control items like organization and location and both items contains lovs.here i have to make location lov is dependent on organization.one org contains multiple locations. how to make this change?

View 1 Replies View Related

Forms :: Triggers In 6i / Which Is Applicable To All Items

Jan 24, 2012

May i know the triggers in forms 6i, which is applicable to all items,blocks and form.

View 9 Replies View Related

Forms :: Moving To Next Record From Detail Table?

Feb 1, 2013

I have create Master block and a Detail block.When i am clicking on the Master block, then details records are displaying.But when i m moving from 1st record of detail block to 2nd record of master block, then detail block's data is not not displaying.It just firing the validation of detail block's first field.

when from Detail block (Cursor on the field Mapping code field) clicking on the 2nd records i.e Ord.No. =2 , at that time validation is getting fired.)

What i really wants that if click on the 2nd record of Master, automatically records should display in detail block.

View 3 Replies View Related

Forms :: How To Save Tlist Items In Database

Sep 25, 2010

my question is this that i have tlist items like

example:

A
B
C
D
E
F
G
H

how to save tlist items in database.

View 6 Replies View Related

Forms :: Multiple Items With Same Database Column Name

Dec 28, 2010

I am coming across a requirement wherein a databse cloumn is shred by 2 fields..( need to append the value to the data-base column for the 2nd field.

I dint test it yet but the form compiled with warning FRM-30431: Warning: Duplicate column name in same block...is it ok to further go or its not allowed at all?

View 3 Replies View Related

Forms :: Hangs With Large Text Items

Oct 4, 2010

I'm facing a strange problem with one of my client.

Sometimes the application hangs when they are typing in text item defined with 2000 or 4000 char long.

The application needs to be close manually.

The first time we faced the problem, we tought it was due to database locks but the DBA confirmed that everything was OK.

The OAS admin also tried to log the application but nothing special. So we tried to run the application using JRE instead of JINITIATOR and the problem disappeared.

So, my question is, is there known bug about using large text item in Forms 10G? and especially with JInitiator? I tried to find informations on metalink but found nothing.

View 1 Replies View Related







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