Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verification on IIF() in SQL clause
Message
 
 
À
16/03/2003 01:08:24
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:
00766272
Vues:
22
>>Are you taking into account one extra run that VFP does on first phisycal record in the table to determine the fields size?
>
>I'm not sure what you mean.

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.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform