This way you still use 8 filter conditions on view's SELECT SQL Where clause, even if some conditions are empty (btw it works because you have SET ANSI OFF). However, 8 conditions will still require to have 8 index tags on table to provide Rushmore and even with fully rushmored SQL it may work slower for large data volume than if you will have just one filter condition whixh is really entered.
>Ed,
>Thanks for responding, I will look into the SQL. I want to let you know the user only uses one of the text boxs on the search form the one they pick, thru my code in the valid box I set the other parameters with no value.
>
>example:
>User want to search on name:
>lcSname = alltrim(text1.value)
>lcAccount = ' '
>lcSaddress = ' '
>etc,
>
>Then when I run the query the only thing it looking for is lcSname the other parameters has no value.
>
>If you see a problem with that please let know. wright now it works but I don't have that many records in the table.
Edward Pikman
Independent Consultant