Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
George;
There are a lot of things we can do with VFP that other development languages will not allow. The IIF in the Select statement of the original question got me to thinking: How would Visual Basic handle this, if it could. As we know, an IIF in VB behaves very differently than it does in VFP. For a SQL Select statement it would be a real “hit”. The SQL code would be run three times : First the left side of the equality sign, next the right side and then it would evaluate the correct answer. Can you imagine that at end of the month close out for the accounting/purchasing department at a large corporation? Just a bit of a network hit.
Tom
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement