New topic: RealSQL: Datatype of computed fields and reports
<http://forums.realsoftware.com/viewtopic.php?t=33859> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message hvanschaick Post subject: RealSQL: Datatype of computed fields and reportsPosted: Wed May 19, 2010 10:08 am Joined: Mon May 03, 2010 4:45 am Posts: 1 Hi! I have defined a report with fields that have a format string associated to it like '###.##' to format the data correctly on the report. This works fine with a column that is defined as Double. However, when I use a computed column like Round(<col a>/<col b>,2) the formatting is not applied anymore and the raw result is produced as if the column is a string like '1234.67388388838' The same applies to views that contain computed columns... Is this a bug? Does a workaround exist?? I tried using 'CAST' but no difference... Any input appreciated.. Hans 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]
