Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine if char field in a table is a number
Message
From
26/06/2009 11:39:42
Naomi Nosonovsky
Wisconsin, United States
 
 
To
26/06/2009 11:37:03
Sergio Ortiz
Tek Services Group, Llc
Hollywood, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Determine if char field in a table is a number
Miscellaneous
Thread ID:
01408688
Message ID:
01408690
Views:
80
>Hello All,
>
>How determine if a char field in a table contains a number ?
>
>
>Thanks

May be
TRY

   if transform(val(CharField)) = CharField
           ** It is numeric
   endif
catch to loException
endtry
Though this test doesn't cover correctly all cases, such as 12E9, etc.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform