[Stackoverflow] [Progress OpenEdge ABL] How to validate against item master table

Status
Not open for further replies.
H

Hugh Jass

Guest
I am creating a custom report screen in which I have a fields item number, item type, prod line and status and there is a condition for item number that is I have to validate it against pt_mstr which from what i understand means that the item number that I enter should be present in pt_mstr. And if it's blank then give an error. I've done the validation for blank with this code

Code:
If lvc_part = "" then do: 
{us/bbi/pxmsg.i &msgnum=40 &errorlevel=3} 
Undo mainloop, retry mainloop.
End.

Lvc_part is the variable i declared for item number and mainloop is the loop inside which I'm writing my entire logic. I am getting the general idea for validating item number against pt_mstr but I'm not getting how to put it down as a code. I'm thinking we need to include a find first query to see if the item number is present in pt_mstr or not but I'm not sure. Any leads would be helpful, if you want to know anything regarding the declarations I've used or anything else let me know. Thanks in advance!

Continue reading...
 
Status
Not open for further replies.
Top