Re: Searching values all-over the database

Are you trying to search every field in every table in the database or do you just want to search text fields in some tables in some columns? "A" way to do this would be to write a procedure in your language of choice that queries the systables and syscolumns tables. Use this information to construct queries like select <table>, <primary-key-info>, col from <table> where col like "%search_value%"; You could also just create your own table of where to look and walk that table for your searches similar to the above but you manage what you want the user to search just in case you have internal text columns that you don't want the user exposing. It is open for debate if there is a smart way to do this. (some people believe there is no smart way to do a dumb thing. I'll let the philosophers in the group argue about that. Of course some ways of doing dumb things are dumber than others. ;-) ) As for your pocket organizer searching "everything" it really is only searching user entry fields and not its internal structure fields. Which is why I asked what you were trying to do. Joachim Engel wrote: > Hi, > > is there a smart way to search any value all-over the database > regardless in which column it is stored? > > We are using IDS 7.31. > > TIA, > Joachim Engel.