Home » Developer & Programmer » Forms » Inserting and deleting records (Windows XP Oracle Forms 6i,)
Inserting and deleting records [message #317994] Mon, 05 May 2008 04:22 Go to next message
*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
Re: Inserting and deleting records [message #318010 is a reply to message #317994] Mon, 05 May 2008 05:44 Go to previous messageGo to next message
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.
Re: Inserting and deleting records [message #318231 is a reply to message #317994] Tue, 06 May 2008 03:02 Go to previous message
*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
Previous Topic: Difference in COMMIT, COMMIT_FORM & FORMS_DDL( ‘COMMIT’ )?
Next Topic: Chnage the value of the field (just for demo)
Goto Forum:
  


Current Time: Tue Dec 06 15:56:46 CST 2016

Total time taken to generate the page: 0.16042 seconds