Forms :: Quit From Form With Items Having Primary Key?

Aug 21, 2010

I have build a form based on a table with 2 columns,one of which isprimary key. I have created a Button with name "Quit".For that i used when-button-pressed trigger with built in "exit_form". But when I run the form,with out any execution of query or any action if I press "Quit" button,it is not working

The error message is "FRM-40202 : Field must be entered" Then I used a trigger to the item with primary key.when-new-item-instance:

set_item_instance_property('CUTOMER.CUSTID',CURRENT_RECORD,REQUIRED,PROPERTY_FALSE);

While using this,the error is "unable to resolve reference to item customer.custid" Cutomer is block name & custid is textitem with primary key. canvas used is Tab canvas with 3 tab pages with master detail relation b/w thwm. The primary key is required compulsory at the time on inserting.

View 1 Replies


ADVERTISEMENT

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 :: Material Form With Master Items - Insert And Update

Apr 4, 2012

i have (ship_master-ship_detail) receive material form.when open the form all the master items appears except receiver name and receiver id. when i select the receiver name and id thru lov...all the items (with send information)in ship_detail also comes up expect rec_qty.i put the rec_qty and save from.

now i want to insert(ship_detail) information in another table apart from ship_detail table. if that particular matrial already exist in table it shud only update receive quantity column with +. if i am receiving the material first time then it should just insert a record with ship_detail items.

so where should i write the insert and update.

View 1 Replies View Related

Forms :: Quit Excel From Oracle 10.1.20.2

Jan 22, 2013

I am using Oracle forms 10.1.20.2 and Excel 2007.

I have written the following code to Quit Excel But This removes Excel from the desktop but the application still runs. If you view the task manager you see all the excel application there taking up all the recourse.

ole2.release_obj(worksheet1);
ole2.invoke (workbooks1, 'Close');
OLE2.release_obj(Workbook1 );
OLE2.release_obj(Workbooks1 );
ole2.invoke (application, 'Quit');
OLE2.release_obj(application );

SYS.DBMS_SESSION.free_unused_user_memory;

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

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

View 0 Replies View Related

Application Express :: How To Fetch Tabular Form Column Value Into Page Items

Sep 7, 2012

I have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.

I am using apex 4.1

View 12 Replies View Related

Application Express :: How To Align Items In A Form Page With Respect To Regions

Oct 16, 2013

I have 20 item fields in same form. i need to align them in sequential manner. For example x  y   z  abcl  m  o p   q   r   s   xyzabclmopqrs  are the items to achieve this what i have to do...

View 2 Replies View Related

Application Express :: Create Items Context Help Editable Report Or Report And Form App

May 9, 2013

How do I create Items context help editable report or report & form app?

what is its table?

View 2 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

ODP.NET :: Visual Studio 2012 Update 2 - Wizard Quit Working

Apr 22, 2013

I had installed ODAC 11.2 Release 5 (11.2.0.3.20) and Update Model from database wizard was working as expected...then after installing update 2 the wizard quit working....So Installed the latest managed drivers and beta..Data Connection connect and I can see the views and tables. but the Update Model from database wizard does not show the views and tables..

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 :: 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 :: 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 :: 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 :: 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 :: 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 :: 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 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

Forms :: Beans Items To Manage Movies

Apr 27, 2010

My technical envirment is Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i.

i want to create a form conatining a BEAN item through which i want to insert and select a BLOB movie from a Table in a database.

View 3 Replies View Related

Forms :: Disabling Default Menu Items In Oracle 10g?

Aug 3, 2010

How to disable the Default Menu Items like (Edit - copy,Paste) in oracle Forms 10g.

View 1 Replies View Related

Forms :: How To Insert Column Values Into Text Items

Dec 30, 2011

I have created the Textitem with five instances.

i am trying to assign column values to text item through query.

if my table contain one record,it shown in textitems.But if my table contains more records it is showing ora-1422 err.how to solve it.

View 1 Replies View Related

Forms :: Enable / Disable Menu Items For Different Users?

May 14, 2011

Enable / Disable menu items for different users.

how to create different users give in demo files i am using 10gforms.

View 1 Replies View Related

Forms :: Multi Record Block Not Displaying Items

Feb 12, 2012

I want to ask what's wrong with my multi-record block.

When i click a node on my tree, it should display the records on it. For example, my root node is Sections, the parents are 1st sem and 2nd sem. In each sections in 1st sem, whenever i click a child node, it should display on display items. I have set its number of items displayed to 9. Since each sections have 9 subjects. The problem when i run it is that it displays many rows.

View 35 Replies View Related







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