Select-options filter in sql search.
i am giving parameters to filter my search in sql statement but i want to change it to select-options.
i have searched the web but i couldnt find anything.
here is my code:
OPEN C FOR
SELECT MAGAZAKOD, STOKKOD, ADET, BRUTTUTAR,
INDIRIM, NETTUTAR, PROMOTIP, PROMOKOD
WHERE MAGAZAKOD = :P_WERKS AND
TARIH = :p_budat
i want to change p_budat and p_werks.
thanks in advance.