OraFAQ Forum: Forms » Update field

Home » Developer & Programmer » Forms » Update field (Windows XP Oracle Forms 6i,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Update field [message #309004]

Wed, 26 March 2008 03:54

*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

Report message to a moderator