Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec to return empty record
Message
From
19/03/2003 10:39:51
 
 
To
19/03/2003 09:54:38
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00767402
Message ID:
00767586
Views:
11
>
>>... 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
Previous
Reply
Map
View

Click here to load this message in the networking platform