Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is SPT equivalent of NODATA ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00463996
Message ID:
00464411
Vues:
21
Thanks Hector - I'd misremembered.

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!)
>
>What VFP sends to SQL Server when you especify NODATA is "SET FMTONLY ON/OFF" For example, if you open a view that queries the EMPLOYEE table with NODATA, VFP will send:
>
>set fmtonly on
>select * from employee
>set fmtonly off
>
>Yet, sending "select * from employee where 1=0" seems to be equally effective


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform