Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF in a SELECT
Message
De
09/03/2000 15:02:25
 
 
À
09/03/2000 14:55:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00343773
Message ID:
00343812
Vues:
26
Yes, the first version was not working for ? reason. !!

In my form, I have some ole control (teechart graphics), and after my select, i put the ole control visible.
After that, VFP send me a messagebox with the text "Floating point division by zero."

I don't really know why, but the version #2 corrected the problem.

Thanks David !

>Stephane,
>
>>I try it and it is very good !
>>Maybe it is not the best solution, but I call a function() in my Select for rhe fields that I use the "iif" command.
>>
>>Example :
>> (before)
>> Select field1,iif(field2=0,0,field3/field2) as nDiv from myTable
>>
>> (after)
>> Select field1,MyFunction("iif(field2=0,0,field3/field2)") as nDiv from myTable
>>
>>function MyFunction()
>>lParameters tcCalcul
>>return evaluate(tcCalcul)
>>
>>Thanks David !
>>Your help was very appreciated ! :)
>
>What is the difference in the two versions? Did we make something better? Was the first version not working for some reason?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform