Error in Price List report Customization

N

Namasiva

Member
Hi,

For a requirement i have created a program (attached here with)
and compiled, i haven't get any error while compilation, while running the program i am getting the error as below

==========================================================
** FIND FIRST/LAST failed for table pt_mstr. (565)
** t1_list already exists with "Wetting Agent ". (132)
Press space bar to continue."
===========================================================

Pls look in to the codes and help me out to resolve the issue

Thanks in advance
 

Attachments

find first pt_mstr where pt_mstr.pt_domain = global_domain and
pt_part begins pi_part_code and pt_status ="Ok" No-lock.
-> NO-ERROR is missing

Add -> if available pt_mstr then

find first t1_list where t1_part = pt_part no-error.
 
Hi Chari,

Thanks for your reply

i made the changes as below :

find first pt_mstr where pt_mstr.pt_domain = global_domain and
pt_part begins pi_part_code and pt_status ="Ok" No-lock no-error.


find first code_mstr where code_mstr.code_domain = global_domain
and code_fldname = "pt_part_type" and code_value = pt_part_type no-lock no-error .

if available pt_mstr then

find first t1_list where t1_part = pt_part no-error.


still i am getting the error as

======================================================

** FIND FIRST/LAST failed for table code_mstr. (565)
** t1_list already exists with "Wetting Agent ". (132)
======================================================

Pls help me out to get rid off this issue.

Thanks in advance
 
The rule is ALWAYS use NO-ERROR with find statement.

If there are cases that record could exist or not use if available statement.
 
You must log in or register to reply here.
Back
Top