Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec to return empty record
Message
From
19/03/2003 09:57:30
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00767402
Message ID:
00767542
Views:
10
>Had you succeed to execute
>
>... where .f.
>
>on SQL Server ?!
>.F. is not valid for SQL. We usually use (TableID < 0) as contidion for retreiving empty cursors. If you insist to hold your current way of giving WHERE condition you could write some expression that always evaluates to false. ForExample:
>
>... where (0=1)
>
When I executed that at first, I had the assumption it was returning all records. However, it was the previous cursor. When checking the result, I found that it was -1.

Yes, I want a condition that is not dependent on the table. The structure of each table differs so I need something generic.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform