OraFAQ Forum: Forms » Inserting and deleting records

Home » Developer & Programmer » Forms » Inserting and deleting records (Windows XP Oracle Forms 6i,)

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

Inserting and deleting records [message #317994]

Mon, 05 May 2008 04:22

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

HI guyz,
I have one query. Hope i will get good response from seniors as well freshers.
I have two table master as well details as below
SQL> DESC ASSET_MASTER_NEW
Name

Null?

Type
------------------------------- -------- ----
ID_NO VARCHAR2(15)
USERNAME VARCHAR2(40)
BOOK# NUMBER(6)
ARN_NO NOT NULL VARCHAR2(15)
DATE_OF_DELIVERY NOT NULL DATE
REMARKS VARCHAR2(200)

SQL> DESC ASSET_DETAILS_NEW
Name

Null?

Type
------------------------------- -------- ----
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(20)
QTY NUMBER(3)
UNIT_PRICE NUMBER(19,2)
DATE_OF_RETURN DATE
REMARKS VARCHAR2(200)
ASSET_STATUS VARCHAR2(15)
----------------------------------------------------------------
im using these table in two forms one Delivery items and second for Received items the most common thing in this field is Asset_Status whic is list item (Delivered & Received )
whenever im delivering some items the status should be delivered and when im receiving same item the status should be Received with Return Date, Remarks
i create another table taking below fields from both tables

ARN_NO,
ID_NO,
USERNAME,
ITEM_DESCRIPTION,
MANUFACTURER,
PART#,
SERIAL#,
DELIVERY_DATE,
RETURN_DATE,
QTY,
UNIT_PRICE

and whenever im receiving any item user should enter return_date whic is not null, and when user commit this form the item whic he recevied should be deleted and insert into another table whic is above and common fields from both tables.
how we can do this?

Waiting for precious replies.....

Regards

Report message to a moderator

Re: Inserting and deleting records [message #318010 is a reply to message #317994]

Mon, 05 May 2008 05:44

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

you can create to table one form receiving and another for delivering.
you can fetch data from receiving table due to this you can manage both data.

Report message to a moderator

Re: Inserting and deleting records [message #318231 is a reply to message #317994]

Tue, 06 May 2008 03:02

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

No Kamaran i dont wanna to create one more table....already there is lots of record. and i dont wanna to make unncessary storage anyhow kamran thanks for your support.

and the good news is i solved it after spend 6 hours....

Thanks for your support guyz...

Regards

Report message to a moderator

Previous Topic:	Difference in COMMIT, COMMIT_FORM & FORMS_DDL( ‘COMMIT’ )?
Next Topic:	Chnage the value of the field (just for demo)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 08:29:50 CST 2025