Hi Tom,

Just to make sure I don't get credit for my error:

I suggested SET ROWCOUNT (which was not what you need)

Hector Correa corrected me and suggested SET FMTONLY (which is what you need).

Bob Archer also found SET FMTONLY

(I can't be right *all* the time <g>)

Cheers,

Andrew

>>>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