>>What is the equivalent in SQL-server SQL pass-through of NODATA ? I.e how can I force an empty cursor -- efficiently? (This must be a dumb question!)
>
>Have you tried SELECT TOP 0 ? As in...
> SELECT TOP 0 * FROM pubs
>
>TOP 0 chokes VFP, but MS SQL-Server supports it.
------------
Thanks, Bruce. I thought I'd try that, since it looked from the SQL-server doc that TOP 0 was the same as setting a temporary record limit. I was also planning to try the FMTONLY that Andrew suggested.
BTW, I have a friend here named Allen Bruce.
-- Tom
Tom Green in Montreal