You could construct the WHERE clause as a string first including only textboxes with values in them and then macro substitute into the SQL SELECT.
>Hello,
>
>I am using Visual FoxPro 6.0 and I am making a search-form. On the form there are 8 textboxes, 1 button and a grid. If I fill in the textboxes and push the search-button a select-command is being executed and the results are put in a cursor with the following command:
>
>SELECT <...> FROM <...> INTO CURSOR cursorname WHERE <...>
>
>The grid is then using the cursor to show the results.
>
>I am using one select-command to search in the tables for the values in all the textboxes. The problem is that if I leave a textbox empty, the select-command is searching for empty fields. Is it possible not to search for empty textboxes with one select-command?
>
>Thank you for your time.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.