New topic: Currency column assigns correctly in SQLite not Real Server
<http://forums.realsoftware.com/viewtopic.php?t=32133> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message thansen Post subject: Currency column assigns correctly in SQLite not Real ServerPosted: Fri Jan 22, 2010 12:33 am Joined: Mon Feb 05, 2007 11:05 pm Posts: 42 If I do this (amount is a currency column) in both SQLite and Real Server: Code:INSERT INTO mytable (`id`, `amount`) values ('730', '20') Then if I do this in each: Code:select * from mytable where id=730 I find that Real Server has actually stored an amount of 0.002 while SQLite has correctly stored 20? How can this happen? Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
