Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data type mismatch when im checking for the null
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00341920
Message ID:
00341924
Views:
17
Kelly,

Check the VARTYPE() of the array element instead:
if inlist(VARTYPE(sales[1,1]), 'N', 'Y')
   thisform.salestax.value = .071 * sales(1,1)
endif
Cheers,

Andrew


>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


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Previous
Reply
Map
View

Click here to load this message in the networking platform