Error coming in lot serial lookup in desktop mode

[shafee212]

An application error has occurred. Reason(s):

An unexpected error application status was returned.
ERROR: com/qad/desktop/interface/wslu.p: Unable to prepare query. Query string: for each ld_det fields( where ld_domain = 'KSMF' and ld_part = '0101' and ld_site = '39' and ld_loc = 'FG-QC' no-lock by ld_lot.
** Unable to understand after -- "ld_det fields(". (247)
** Right parenthesis missing after expression. (253)
PREPARE syntax is: {FOR | PRESELECT} EACH OF.. WHERE ... etc". (7324)


Can someone help on this ..

 

[mosfin]

what happened to your "fields()" clause ?
it should include the fields you need for the FOR EACH block,
e.g: fields(ld_ref ld_lot ld_qty_oh ld_status)