Colin

Not sure whether the following would work, or fail if just one criterion is not fulfilled, but you can give it a bash:

Select .... from ... ;
where Town = lcInputTown and not EMPTY( lcInputTown) ;
  and Country = lcInputC and not EMPTY( lcInputC ) ;
  and ZipCode = lcInputZip and not EMPTY( lcInputZip ) ;
  and ...
  into cursor PostmansSock NOFILTER

or:

Select .... from ... ;
where ( Town = lcInputTown or EMPTY( lcInputTown)) ;
  and ( Country = lcInputC or EMPTY( lcInputC )) ;
  and ( ZipCode = lcInputZip or EMPTY( lcInputZip )) ;
  and (...)...
  into cursor PostmansSock NOFILTER

Note that the NOFILTER clause enables the resultant cursor to be used in your next query, as in

Select ... from PostmansSock ...

If this is connected to your previous question re: "Query is read-only", then, in the query builder, you can open the SQL window and still select and copy the SQL, to get the bulk/essence of it, and paste it into your code, to do the above enhancements.

HTH

Terry



>Hi
>
>I am trying to work out the code for the following
>
>I have 12 query fields - any or all may contain values - I only want SQL to run the query on those fields where the query field is non blank
>
>eg Town = New York Country = USA zipcode (blank)
>
>The query would only work on town and country since the zipcode field is blank
>
>Alternatively I might have to run a number of queries one after using the results from query 1 as the source data for query 2 - is there any way I can do this?
>
>Thanks
>
>Colin