Returning to a text field block again from the query

[user3427690]

I have a form that prompt for customer name and pass that value to a query,


FORM compname customer.cusname WITH FRAME f1. UPDATE compname WITH FRAME f1.

This form wil pass the compname value to the following query,

FOR EACH customer WHERE customer.name = compname NO-LOCK :
if available(company) then
do:
CREATE temptt.
assign temptt.num = customer.kco
temptt.no = string(customer.kco)
temptt.name = customer.name
temptt.status = false.
END.
else
message "not matched " view-as alert-box.
end.


What i want to do is, if search does not receive any rows, it should again prompt for customer name. what should i do for this ??

how do i call that form again in the "else block" and also, currently I am giving the complete name in the field, but i want to give part of the name, for eg., customer name is "John Smith Doe" and if i input "Smith" it should retrieve the related rows. How should i alter the "Where" clause for this ?? Please help me.

Continue reading...