Feb 10, 2015 #1 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
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
Feb 16, 2015 #2 cagiv Programmer Joined Mar 5, 2009 Messages 56 Location DE LONG declares a integer, you have to use DECIMAL (for example DECIMAL(15,2)). cagiv Upvote 0 Downvote