How to search database records effectively
I need to search database table(F4101.DSC1,F4101.DSC2,F4101.SRTX ) against some inputs(say, 3 text boxes named Search1, Search2, Search3). What I did right now is...0. Set cIsFound=0
1. Use "Is String in String" function to search "Search1" against F4101.DSC1
2. If found, set a variable cIsFound=1. If not found, proceed to next step.
3. Use "Is String in String" function to search "Search1" against F4101.DSC2
4. If found, set a variable cIsFound=1. If not found, proceed to next step.
5. Use the above steps to do the same for Search2 and Search3
6. At last, suppress the grid line if cIsFound=0
1. Use "Is String in String" function to search "Search1" against F4101.DSC1
2. If found, set a variable cIsFound=1. If not found, proceed to next step.
3. Use "Is String in String" function to search "Search1" against F4101.DSC2
4. If found, set a variable cIsFound=1. If not found, proceed to next step.
5. Use the above steps to do the same for Search2 and Search3
6. At last, suppress the grid line if cIsFound=0
1