hi everyone,
I created a form with 3 data blocks, all link together with no problems. one of the data blocks may or may not have records for the customer ID selected.
that one particular data block also has an LOV with an LOV button. what I want to do is when a user clicks the LOV button to select a YEAR, and
if no records exist, a message appears stating "No Records Exist". I have the code below but it's not working. I may have it in the wrong area
of the data block. the other data blocks will always contain records. thanks for any help.
this code is in the LOV button.
Begin
GO_ITEM('year');
LIST_VALUES;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE('No Record Exists');
End;