Could you please guide me on how to search for values on a parameter.
For e.g. if I have a parameter on a Material (there could be thousands of values), instead of seeing the list of values the user should be capable of searching the values. Also i am unable to see all the values in the parameter is there any setting I can use to see all the values from the database.
Thank you for your time. what I meant was if there were 10000 values for a perticular filed, can the user search as per his requiremnt. For e.g. if there is filed by name 'Material Description' and the vale for that field as 'Steel for factory' , instead of loooking for 'Steel for factory', if the user gives the value as *Steel* he should be able to see all the vaalues related to Steel.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 26 Aug 2011 at 11:32am
If you are only letting them search for one value use the instr() in your select statement so the end user does not have to remember to type in *'s on either end.
Instr(table.field,?param,1)>0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
