Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert string to long

Status
Not open for further replies.
bobntn2014

bobntn2014

Programmer
Joined
May 5, 2014
Messages
2
Location
US
I have a string field that contains a price example: 1.22
When i save it to a long field it is only 1.00
Any help would be appreciated
 
Sort by date Sort by votes
LONG declares a integer, you have to use DECIMAL (for example DECIMAL(15,2)).

cagiv
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

imemoje
  • Locked
  • Question Question
Execute commands from the string
Replies
1
Views
746
imemoje
imemoje
Jose Pires
  • Locked
  • Question Question
What function to get hashe code clarion 6.0
Replies
0
Views
635
Jose Pires
Jose Pires
Vedant_Vora
  • Locked
  • Question Question
Please suggest a good source or a book to learn clarion
Replies
0
Views
677
Vedant_Vora
Vedant_Vora
FFrreedd
  • Locked
  • Question Question
I am still in search of a method to
Replies
0
Views
331
FFrreedd
FFrreedd
Herman5019
  • Locked
  • Question Question
Clarion - Dictionary - Basic File - Import CSV to TPS
Replies
1
Views
516
sk2107c
sk2107c

Part and Inventory Search

Sponsor

Back
Top