>When I create a filter expression to pass to SQL Server, sometimes I need to indicate that I want all records. In VFP I would pass .T., e.g.:
>
>
>cFilter = " .T. "
>
>
>I tried to do the same for SQL server but it does not work. I tried to use True, still no luck.
>
>Thank you in advance for any suggestions.
Can you just remove WHERE clause alltogheter in that case?
* All records
cDilter = " 1=1"
* No records - empty cursor
cDilter = " 1=2"
--sb--