Another option is to use SET FMTONLY ON before running your query. Only the format of the result set will be returned. The query will not be processed.
-Mike
>I would like to use SQLExec() to return empty record. In VFP, I would simply do:
>
>
>SELECT * FROM News WHERE .F.
>
>
>but, from VFP, to query from a SQL Server table, doing this:
>
>
>SQLExec(lnHandle,'select * from dbo.News where .f.')
>
>
>returns all the records. What is the proper syntax to use?