| When_validate_item and When_validate_record Not working [message #689894] |
Sat, 29 June 2024 13:06  |
 |
mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan
|
Member |
|
|
I am new to forms 6i development and I am attempting to establish a master and detail relationship using the Department and Employee tables. The relationship runs perfectly, but I am encountering an issue with displaying the employee address code from the employee table. I have created a new non-database text field called empaddress to display the full address with employee details. However, I need to retrieve the full address from another table named empaddress using the empadd_id code and empaddress as the column name. I have tried using both the when_validate_item and when_validate_record triggers to retrieve the full address through a query, but neither trigger is displaying the address. Can you please review my code and provide me with ideas on how to retrieve the full address in the non-database text field empaddress? Thank you.
see my code
if emp_id is not null then
select ampaddress into :employee.empaddress form empaddress where empadd_id=:employee.empadd_id;
end if;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
