Skip to Content
Former Member
Apr 17, 2012 at 01:37 PM

How to form 'select statement' based on user Search in BSP page...??


Hi Good evening to all...

I have BSP page that contain search Fields..If user enter some value in search fields, The 'SELECT' statement should form based on user input value..


user enter "Male" in Gender search field..The select statement should change like below..

SELECT * from ZDATABASEVIEW into data_table where ZCAND_GENDER = 'Male'.

similarly for some more fields...

Please any one suggest me how to proceed...

I already searched some sdn forum discussion but i didn't get what i need..

thanks and regards