| not display blank fk record [message #175619] |
Sat, 03 June 2006 07:09  |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
Sir I have master detail form
Sir I have father child relation in table
Master is simple
And detail is grid
I have to FK in my detail form one form master and one form other key where I save my all department name
Sir my problem when I not give department no in department column the system save record but when retrieve the record then write code in post-query event for
Accountname and departmentname in gird then system give me error
I use this code in post-query event
select title into :partyname from partytable where partyid=:partyid;
select title into :DISPLAY_ITEM35 from chartofacc where accid=:voudetail.accid;
if not :voudetail.deptname='0' then
select department.title into :voudetail.deptname from department where deptid=:voudetail.deptid;
end if;
and not retrieve that record whose have blank FK of department table
please give me idea how I get data
thank
aamir
|
|
|
|
| Re: not display blank fk record [message #176365 is a reply to message #175619] |
Thu, 08 June 2006 02:16  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Use an 'exception' testing for 'no_data_found' and either just leave the value empty or perhaps place 'not found' in the output field.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
