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 Mike Lewis 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
May 5, 2014
2
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
Execute commands from the string
Replies
1
Views
211
imemoje
imemoje
Jose Pires
  • Locked
  • Question
What function to get hashe code clarion 6.0
Replies
0
Views
195
Jose Pires
Jose Pires
Vedant_Vora
  • Locked
  • Question
Please suggest a good source or a book to learn clarion
Replies
0
Views
203
Vedant_Vora
Vedant_Vora
FFrreedd
  • Locked
  • Question
I am still in search of a method to
Replies
0
Views
83
FFrreedd
FFrreedd
Herman5019
  • Locked
  • Question
Clarion - Dictionary - Basic File - Import CSV to TPS
Replies
1
Views
113
sk2107c
sk2107c

Part and Inventory Search

Sponsor

Back
Top