Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 297 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Converstion Text data type to Decimal
smc
Member Posts: 41
How we can convert a text data type to decimal
Eg:
codnumber (datatype code value '10.56')
i want to convert to decimal value 10.56
is it possible then how.
Hoping Realy
SMC
Eg:
codnumber (datatype code value '10.56')
i want to convert to decimal value 10.56
is it possible then how.
Hoping Realy
SMC
0
Comments
TextVar := '10.56'
EVALUATE(<DecimalVar>,<TextVar>)
Evaluate function returns true or false and hence should be used with an IF condition.
but i want to get that value only from text data type no need to check that data type
If you omit the optional return value and an error occurs during the evaluation of the string, a run-time error occurs. If you include it, the system assumes you will handle any errors.
The text value will be converted to decimal and will be stored in the first parameter provided to the function i.e. DecimalVar