Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting text to Numeric and Date fields
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00167407
Message ID:
00167417
Views:
23
> Can you try and convert it into a temp var and see if it converts?

Michelle,

That's what I am attempting, but VFP will proceed with the conversion and not have a problem. To further illustrate, if in the command window, you enter:

?VAL('ABC')

You get zero. My question is how do I test 'ABC' to see if it is really valid numeric data. Otherwise how do I distinguish between zero and 'ABC'?

Thanks for the suggestion.

Kind Regards,

Mat Kennedy
Decision Support Technology Inc.
Matthew Kennedy
Decision Support Technology Inc.

"I try to take one day at a time, but sometimes several days attack me all at once." ~ Ashleigh Brilliant

New Jersey Dot Net User Group
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform