Forms :: Populate_list For Non Database Field

Feb 19, 2010

in my forms,1 block(multi record)) which has 5 database columns(c1,c2,c3,c4,c5) and 1 non-database column(s1).Forms shows column c4 ans s1. I use populate_list on s1 column on basis of value c1,c2,c3 using system.mouse_record to fetch respective record values in the list.

but getting problem of list pop up size and return value on selecting value from pop up list. means clicking on 1st record and selecting value(e.g val1),its return "val1" after that clicking on 2nd record and selecting value(e.g xyz),its return "xyz" but at that time 1st record value become "xyz" instead of "val1".mns its replace all values with current selected value from the list.

Original code for reference as below.

---------------------------------------
PROCEDURE S_VALUE_LIST IS
rg_id RecordGroup;
lst_id Item := Find_Item('SNSPECMST.S_VALUE');
ERRORCD NUMBER;
t_srno1 number := 0;
t_srno2 number := 0;
t_srno3 number := 0;
BEGIN
[code]...

View 11 Replies


ADVERTISEMENT

Forms :: Query Not In Database Field

Nov 27, 2010

i have a single form three database field

i want when i open a form in exceute mode then only a single field it does not show any data from database

means query not allowed in that particular field

how it is posible

View 1 Replies View Related

Forms :: Linking A List Box To A Database Field

Aug 3, 2010

I remember a method in which I used a property in the property pallete to specify the query in which i wanted the list linked with, it gave me the option to input a static list or as mentioned a dynamic list which was dependent on a query entry, but I cant for the life of me remember where this property was.

View 4 Replies View Related

Forms :: Take Pic From Cam Window And Save It To Field In Database

Dec 21, 2012

I have a requirement to take pic from a cam window and save it to forms field in database.

View 2 Replies View Related

Forms :: Validating Field With Data In Database?

Aug 6, 2010

I currently have a field in which the user inputs a number, but before this number is allowed to be saved to the database it has to be checked to see if the number is already stored in a different field within the database. For example, if the number is not in the database the user cannot put that number into the field.

I do want it to be user input so I don't want a LOV linked to the appropriate field in the database.

Is below anyway close to the way it should be done? For some reason seq_rec.seq seems to give me 3 and doesn't seem to compare it with each of the values in the database.

DECLARE
cursor seq_curs IS SELECT SEQ FROM ZZJOB;
seq_rec seq_curs%rowtype;
none_existing_seq EXCEPTION;
invalid_seq EXCEPTION;
return_alert NUMBER;

[code]....

Just say the field in my database has numbers: 1 2 3 4 and 5 in the field that i allow the user to input data they can only enter 1 2 3 4 or 5. Hence the check needs to be made with te database field to check if the input number is already in the database.

P.S. they are separate fields for different things, the numbers just need to be in one field before they can be added in the other.

View 5 Replies View Related

Forms :: Insert Image Into Database Field By Scanner / Camera

Jul 7, 2011

i'm using form 6i and oracle databse 10g i want to insert an image into database field(BLOB) from scaner or camera

i have been search about this in this forum but no thing

any example

My Email :[URL]....

View 4 Replies View Related

Forms :: How To Pass Excel General Value To Database Tables Date Field

Jun 17, 2013

i've following code

declare
i INTEGER:=0;
flag boolean:= FALSE;
vcInsert:='INSERT INTO CRM_DELT_IMPORT (';
if length(i_vcColumn1) > 0 then
flag:=TRUE;

[code]....

i am fetching data from excel all data is of general type, here i am passing value is VTDATE varchar2(100) but actual database column filed is DATE , How can i pass '13-06-13 05:54:33' to database table.

if i put this condition
vcInsert:=vcInsert|| ','||''''||i_ldata(i).to_char(VTDATE,'DD-MM-RR HH12:MI:SS')
i get the error
to_char must be declare.

if i remove this line

i am getting this error ORA-01843: not a valid month

View 8 Replies View Related

Forms :: Update Field Based On Another Field Checkbox

May 3, 2013

I have a table where i need to update one field values based on another field of the same table , simply as it is.I have done this using one select all check box , on clicking that all check boxes of item_trans table will get selected , then i will un select some of check box and then using one button, i will update the value of the fields which are checked only.

I have put the sample code but when i am updating its taking long time and hanging.I am also attaching the form based on the test case provided.

--tables with insert statement
create table item_trans (trans_item varchar2(12),trans_qty number,trans_act_qty number)

insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE1',40,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE2',20,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE3',20,NULL);

--i want to set the value of trans_Act_qty as trans_qty

--i create one dummy or test block to keep the select all check box. for that table test script is

CREATE TABLE TEST
(
C VARCHAR2(2000 BYTE),
B NUMBER,
A NUMBER
);

insert into test (C,B,A) values ('A',1,1);

--code written in select all check box which is created on test.block.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
:M_END_YN := :M_END_ALL;
[code].......

--code written in M_END_YN ( actual check boxes where i will uncheck).

IF :M_END_YN = 'N' THEN
:M_END_ALL := 'N';
END IF;

--code written on button to update those values which are checked.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
IF :M_END_YN = 'Y' THEN
[code]......

View 5 Replies View Related

Security :: Database Field Size

Nov 28, 2012

We have Employee table, there is a field name Employee_no. field size is 6.can we restrict some one not to increase or decrease the field size of Employee_no. even User has admin role.

is there any way to restrict admin user that he should not allow to enter the value of field more or less than 6 characters through Toad or SQL Plus 8.0.
------------------------------------------------------
for example

field: employee_no
feild_size: 6
field_type: Varchar2

When we enter Employee no A000001(7 digit) then database not allowed to update because its field size is 6 characters we want to restrict admin user in Toad or SQL Plus 8.0 because he is Toad and SQL Plus user.

View 6 Replies View Related

PL/SQL :: How To Check Where Table Field Was Used As Foreign Key In Database

May 9, 2013

i have a field in my table office i got field office_code ,this field is been used in diffirent tables as foreign key is there a sql i can wirte to see all tables who have used this field as foreign key.

View 12 Replies View Related

Oracle Database In Automated Fashion By Timestamps Field?

Apr 28, 2008

Is there a way to query an oracle database in an automated fashion by a timestamp field based on current timestamp, like: 04/29/08 00:00:00 - 72 hours?

View 3 Replies View Related

Forms :: One Lov For Different Field

Feb 22, 2011

i want to call same lov for 3 diff. field.....if possible how can i call it...because while desiging lov , returns item only 1 out of 3 field..how can it possible.

View 1 Replies View Related

Forms :: Format For SSN Field

Jul 16, 2010

I have a ssn field where the user enter value to search for the ssn. I want to format the field so the user can enter in the xxx-xx-xxxx format only. If the user enters a wrong format and tries to search i should prompt a message saying wrong format. How can i achieve this.

View 3 Replies View Related

Forms :: 4.5 - Change Value Of One Of The Field

May 24, 2010

I have been asked to support an application which was developed in Forms 4.5. I have experience in Oracle database but I'm almost zero in any front end development.

As a first task I have been asked to remove a couple of field from one of the screen and then change the value of one of the field.

View 4 Replies View Related

Server Utilities :: Field In Datafile Exceeds Maximum Length For Number Field?

Apr 23, 2010

Even though i am using COL1 CHAR(500) NULLIF COL1=BLANKS, then also i am getting same error for those columns.

View 13 Replies View Related

Forms :: Make Field Non Editable

Jul 29, 2010

I have a field on the form which is a database field and the value is populated by a LOV. The user should not be able to edit the value selected or enter his own values in the field. Basically the field should only be populated by the lov and should not be editable.

I tried using the SET_ITEM_PROPERTY('XX.XX', UPDATE_ALLOWED, PROPERTY_FALSE); but this only disable update against existing value. If a user selects a new value from LOV that can be edited.

View 8 Replies View Related

Forms :: Total Field From Another Block

Jun 14, 2013

I have 2 blocks named emp,emp1 those are DB's Blocks and empno, ename, sal in EMP block and sal, sum(sal) are in EMP1 block, i set the property for sum is summarized block is: EMP1 and item is SAL, i want display sum(sal), but not display when i click execute query.

View 5 Replies View Related

Forms :: FRM-40202 Field Must Be Entered

Jan 31, 2010

FRM-40202: Field must be entered.I have a custom form,developed by someone few years ago. While doing a F11 (query-find) in this custom forms in Oracle application, I get the message FRM-40202 Field must be entered because I have some mandatory fields.Below are the steps I follow to reproduce this bug.

- Open custom form
- Enter data/values in all mandatory fields.
- save. It saved back in database.
- then CTRL+F11 to see all the records.
- Only first two records are showing in the screen.
- And "FRM-40202: Field must be entered." at the bottom.

View 12 Replies View Related

Forms :: Dynamic LOV For Sub-Inventory Field?

Jul 20, 2010

I have one requirement.I am populating LOV dynamically for the subinventory field in the order form through custom.pll.

If Dropship flag= 'Y' then populate suninv LOV with D1,d2..values.If it is 'N' then populate suninv LOV with w01,w02,....values.This is done and working fine in the form.But If i save dropship flag='Y' and Subinv value is D1 then it saves the record.Now I am changing Drop ship flag as 'N' then 'D1' value appearing in the SUBINV field.and it allow the save changes.

So How can i refresh Lov at the time of making drop ship flag as 'Y'/'N'?

View 6 Replies View Related

Forms :: FRM-40202 - Field Must Be Entered

Mar 13, 2013

I'm having some columns in my form with required_property set to yes. When I'm trying to query FRM-40202 appears.

View 3 Replies View Related

Forms :: Field Column Setting?

Sep 30, 2013

I am currently working on a bug that came from a user. An oracle form is used for entering employee information and the backend table is employees. One for the field here is LAN ID. It was found that some users were using space bar either before or after entering the Lan id and this is causing issues in finding the employees in the system. A request is being submitted to not let any blanks or space to be entered in the field. In the table, this particular field/column datatype is varchar2 and the size is 8.

How do I make no blanks or spaces to be entered in the field or otherwise, even if they put a space or blank, the field should only use the actual ID entered.. Is it possible?

View 9 Replies View Related

Forms :: Validate Time On Field

Aug 22, 2010

I have a varchar field and user will enter the time in that field as per the format HH:MI HOURS:MINUTES.Actually there is no control on this field and user is making mistakes like instead of HH:MI he is entering HH;MI.

View 1 Replies View Related

Forms :: Date Field With Time

Feb 16, 2010

I have a display item form field. The field's data type is date. It is also a database field that corresponds to a date field in the table.

I have set the format mask on the form field to
MM/DD/YYYY HH24:MI:SS

I can populate that field with sysdate in when-new-form-instance.

However, if I try to get the date and the time in the field, it just populates the date with the time of 00:00:00.
(02/16/2010 00:00:00 for example).

I have tried several to_char and to_date variations but can't seem to get the current time into that field.

View 5 Replies View Related

Forms :: Using LOV On Some Field To Retrieve Data

Jun 8, 2011

I am using LOV on some field to retrieve data, but sometimes it does not retrieve anything cause of unavailability of date its fine but i want to put N/A in that field when such condition is occurring .

View 2 Replies View Related

How To Enable And Disable A Field Dependent On Another Field In Apex

May 9, 2013

I am New to Apex. Im using Apex Version 4.2.

I have a tab named APPROPRIATIONS it has 10 fields. Among which is PROJECT NUMBER, AUTHORIZAION DATE (CALENDER TYPE POPUP), And FUNDS CHECK FLAG.

The Scenario is depending upon PROJECT NUMBER the Fields are Populated including FUNDS CHECK FLAG .

But the AUTHORIZAION DATE is a MANDATORY field has to be filled by User

The Requirement is to make AUTHORIZAION DATE as MANDATORY only when the FUNDS CHECK FLAG is *"BLANK "* or *ā€œYā€*

If the FUNDS CHECK FLAG is *ā€œNā€* then the AUTHORIZAION DATE to be made OPTIONAL.

View 2 Replies View Related

Forms :: Highlight Field Value With Blue Color

Jun 25, 2011

My requirement is, when ever cursor entered into a field, the value of the field will highlight with Blue color and text color will be white, if field is not empty. It the feature of oracle application.

View 5 Replies View Related

Forms :: One Column Show Two Field Also Update

Jun 23, 2012

I have a table in which three field.

1)empid (Save employee code)
2)attendace_time (Save Date and inout time)
3)status. (Save in out Status).

I generate new form. which have four field.

1)empid
2)attendance_date base on attendance_time 3
3)Attendace_time base on attendance_time
4)Status .

Problem is that when i update the Attendace_time . date save first date of the month. when i update the attendance_date time save 12:00

View 1 Replies View Related

Forms :: How To Restrict Update In S Specific Field

Jul 9, 2012

I'm trying to restrict update in a specific field in my form . I have set its property(update allowed) to no and still the field is update able. I am also having on-commit trigger in my form level that well display a message and followed by the command commit. is it possible the trigger is overriding the property(update restriction).

View 9 Replies View Related

Forms :: Validate Field To Be Valid Email ID?

Feb 16, 2011

want to validate a field to be a valid email id.

View 1 Replies View Related

Forms :: Continuous Update Of Calculated Field?

Aug 6, 2013

I have seen in probably VB or Dot net software being used at some premises that there "formula computation is live and interactive".

What i means that suppose a cashier has made invoice having total of 83$. Mow in the text box for entering amount received, the cashier is about to enter 100 but surprisingly the returned value/remaining value (total invoice - amount received) is being computer LIVE.

This is what happens.

1) The cashier entered 1 and the remaining value instantly showed 82 (83-1)
2) then on other key stroke of 0 by cashier and then then the remaining value instantly showed 73 (83-10)
3) then on other key stroke of 0 by cashier and then then the remaining value instantly showed 17 (83-100)

Hence a continuous updation/changing of the remaining value on every key stroke is observed.

View 3 Replies View Related







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