OraFAQ Forum: Forms » save data in block details

Home » Developer & Programmer » Forms » save data in block details

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

save data in block details [message #562125]

Sat, 28 July 2012 18:41

hassan08
Messages: 122
Registered: June 2011
Location: egypt

Senior Member

i have two tables
emp data
emp course
emp data the primary key is emp_no and another table emp course emp_no is foreign key
and desgin
master block and desgin details block
master block programmed list of value to show the employee and make it database item = no
details block show all data i want only save in the details block only
how can make it

Report message to a moderator

Re: save data in block details [message #562132 is a reply to message #562125]

Sun, 29 July 2012 03:38

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A classic (read: created by Data Block Wizard) master-detail form.

Set master block's INSERT and UPDATE ALLOWED properties to "NO".

Forget about non-database item - you don't want to do that. If you insist on non-database block, then master block doesn't have to be a data block (but control block). This solution is less flexible than usual master-detail one.

Report message to a moderator

Re: save data in block details [message #562141 is a reply to message #562132]

Sun, 29 July 2012 11:24

hassan08
Messages: 122
Registered: June 2011
Location: egypt

Senior Member

thank you but know i converted the items to database block = yes and i want only when delete data from details tables without delete data from master tables

Report message to a moderator