I need to have general search utility for my powerbuilder window. If i click on search button then, it should take all the current datawindow columns and perform a record search based on the selection criteria.
For Ex :
I have item_id,item_desc,item_qty
I need to get all these three fields in dropdown in my search window and i should be able to give inputs like item_id>10 and item_desc like 'VIDEO%'. Then if i click OK, i should get records based on that inputs. Tomorrow if i add one more column then, that also should populate in the dropdown in search window. I am not using PFCs in my app.
Thanks in advance