Home » Developer & Programmer » Forms » Update field (Windows XP Oracle Forms 6i,)
Update field [message #309004] Wed, 26 March 2008 03:54 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi guyz,

I have the below table
Master Table
ID_NO VARCHAR2(15)
USERNAME VARCHAR2(30)
BOOK# NUMBER(6)
ARN_NO NOT NULL VARCHAR2(15)
DATE_OF_DELIVERY DATE
REMARKS VARCHAR2(200)

Detail Table
ARN_NO VARCHAR2(15)
ITEM_DESCRIPTION VARCHAR2(100)
MANUFACTURER VARCHAR2(60)
PART# VARCHAR2(30)
SERIAL# VARCHAR2(60)
DEPT VARCHAR2(20)
PROCURED_BY VARCHAR2(30)
CATEGORY VARCHAR2(15)
OPERATIONS VARCHAR2(15)
QTY NUMBER(3)
UNIT_PRICE NUMBER(9,2)
ASSET_STATUS NOT NULL VARCHAR2(20)
DATE_OF_RETURN DATE
REMARKS VARCHAR2(200)

i have created two forms with these master and details tables.

in form A i didnt use the below three field as below

ASSET_STATUS NOT NULL VARCHAR2(20)
DATE_OF_RETURN DATE
REMARKS VARCHAR2(200)

while in form B i use the whole table but the updated field should be three field as below rest should be display.

ASSET_STATUS NOT NULL VARCHAR2(20)
DATE_OF_RETURN DATE
REMARKS VARCHAR2(200)

how to insert the default value in an Item (asset_status should display Not Received) when i changed the record is shows what i changed (.i.e.Received)

please help me to out from this problem

Thanks and Regards


Re: Update field [message #309013 is a reply to message #309004] Wed, 26 March 2008 04:02 Go to previous message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Use INITIAL VALUE property of the Display item so that it will show you desired value by default.

Regards,
Azam Khan
Previous Topic: Very Urgent(Passing Parameters)
Next Topic: Add_List_Element issue
Goto Forum:
  


Current Time: Tue Dec 06 13:57:32 CST 2016

Total time taken to generate the page: 0.06858 seconds