Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExec to return empty record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00767402
Message ID:
00767542
Vues:
9
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform