Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is SPT equivalent of NODATA ?
Message
De
15/01/2001 18:59:59
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00463996
Message ID:
00463999
Vues:
10
>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!)

The last time I worked with VFP was in 3.0 so this may be outmoded, but I would put WHERE 1=0 in the expression and it seemed to do the trick. (I was attached to an old version of SQL Server - whatever was current in 1996). The data came down MUCH faster than if it actually tried to match the WHERE clause against each record.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform