>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.
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data