package libraries;
import eglderbydb.data.Customer;
library SearchLibrary type BasicLibrary
function NameAndStateSearch_And(lname STRING in,
state CHAR(2) in, customer Customer[])
get customer with
#sql{
select
CUSTOMERID, FIRSTNAME, LASTNAME, PASSWORD, PHONE,
EMAILADDRESS, STREET, APARTMENT, CITY, "STATE",
POSTALCODE, DIRECTIONS
from EGL.CUSTOMER
where LASTNAME like :lname
and "STATE" = :state
order by
CUSTOMERID asc
};
end
end
Volver a Lección 2: Adición de código para la función de búsqueda.