Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verification on IIF() in SQL clause
Message
De
16/03/2003 01:16:43
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00766260
Message ID:
00766273
Vues:
26
>Before VFP can proceed with query it has to determine the size of fields in the result set. To do that it runs query against the first record in the table. This record may not even satisfy query conditions or may be deleted. See PRB: SQL SELECT Statement UDF Executes Twice On First Record mskb #Q133001.

So, this applies to UDF use only in SQL. Ok, that'd make sense I have it in an isolated place as I don't use that approach that much. However, it worked ok in VFP 7. So, I'd assume there's a different way of doing things now in regards to that specific point in VFP 8.
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform