Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data type mismatch when im checking for the null
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00341920
Message ID:
00341925
Vues:
25
>I get this error when i try to mulitply .071 tax with my sold price field. Because some of the soldprices are
>blank and then my varible gets loaded with .F. any ideas what I can do?
>I tried this but it still gives me the mismatch.
>
> if sales(1,1) <> .F.
> thisform.salestax.value = .071 * sales(1,1)
>end if
>
>Thanks Kelly

sales(1,1) = IIF(EMPTY(sales(1,1)) or ISNULL(sales(1,1)), 0, sales(1,1) ) && If it is .F. or 0 or NULL it becomes 0
thisform.salestax.value = .071 * sales(1,1)

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform