Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExec to return empty record
Message
 
 
À
19/03/2003 09:54:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00767402
Message ID:
00767586
Vues:
10
>
>>... WHERE 1=2
>>
>Interesting, that works. But, what exactly does that tell SQL Server in order to returns an empty cursor?

In virtually any Database Manager a False expresion should work to give you an empty cursor, .F. doesn't work by casting stuffs, that's why 1=2 works. I've probe this in Oracle, MySQL, FireBird, PostgresSQL, MS-SQLServer, DBFs, Clarion entities.
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform