Home » Developer & Programmer » Forms » Re: Master Detail Delete
Re: Master Detail Delete [message #78609] Tue, 05 March 2002 12:03 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
SQL> desc product
Name Null? Type
------------------------------- -------- ----
PRDT_CODE NOT NULL NUMBER(8)
PRDT_SPLR_CODE NUMBER(8)
PRDT_NAME NOT NULL VARCHAR2(240)
PRDT_COMMENTS VARCHAR2(1024)
PRDT_ROUTING_NUMBER NUMBER(8,4)
PRDT_EFFCTV_START_DATE DATE
PRDT_EFFCTV_END_DATE DATE
PRDT_CREATE_USER_ID VARCHAR2(40)
PRDT_UPDATE_USER_ID VARCHAR2(40)
PRDT_PROV_SPLA_CODE NUMBER(8)
PRDT_PROV_SPLR_CODE NUMBER(8)
PRDT_OLD_ROUTING_NUMBER NUMBER(8,4)
PRDT_AGRESSO_CUST_NUMBER NUMBER(6)

SQL> desc product_status
Name Null? Type
------------------------------- -------- ----
PRDS_PRDT_CODE NOT NULL NUMBER(8)
PRDS_STAT_CODE NOT NULL VARCHAR2(3)
PRDS_RESN_NAME VARCHAR2(3)
PRDS_OPEN_DATE NOT NULL DATE
PRDS_CLOSE_DATE DATE
PRDS_COMMENT_TEXT VARCHAR2(240)
PRDS_RESOLUTION_COMMENT_TEXT VARCHAR2(240)
PRDS_EFFCTV_START_DATE DATE
PRDS_EFFCTV_END_DATE DATE
PRDS_CREATE_USER_ID VARCHAR2(40)
PRDS_UPDATE_USER_ID VARCHAR2(40)
PRDS_PUBC_PUBL_CODE NOT NULL NUMBER(8)
PRDS_PUBC_CLAS_CODE NOT NULL NUMBER(8)
PRDS_PUBL_CYCLE_ID NOT NULL NUMBER(8)

SQL> --the prod is the master and the prod_stat is the detail
SQL> --the prod stat is in tabular form
SQL> --under delete button, DELETE_RECORD;
SQL> --get error when click in one of the detail(tabular) records and push delete
SQL> --error "can not delete master when details exist
SQL> --I attempted the go_block(),delete_record; this doesn't work
SQL> spool off

The thing is, why would I get the error, I'm clicking in the details, not the master. Also where is the property to set isolated, I can't find it?
Re: Master Detail Delete [message #78616 is a reply to message #78609] Tue, 05 March 2002 23:19 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
it is difficult to trace the error this way. can u send a small form having these two block and reproducing the problem.
Previous Topic: Deleting files from forms6
Next Topic: Have a look at this people, it's strange SQL things
Goto Forum:
  


Current Time: Fri Dec 03 23:10:23 CST 2021