I tried that and I am at a complete loss here. It basically shows all of my decimal data as 0.00 yet when I look at the same db with SQLite Manager in firefox its all there.
The only oddball thing I can see is that some of my data shows NaN in the decimal columns under the SQLite Manager. I guess I am at a loss on how to explain the data getting pulled in showing up the way it is yet I can see it in something else. I believe the data is valid and my other program that dumps that out to the db is correct as far as I can tell. It's a mystery.... ________________________________________ From: [email protected] [[email protected]] on behalf of Ed Leafe [[email protected]] Sent: Tuesday, May 01, 2012 7:37 AM To: Dabo Users list Subject: Re: [dabo-users] Precision Value in Grid Column On May 1, 2012, at 6:16 AM, RUSSELL Thomas wrote: > That code for the self.DataStructure is already uncommented. I commented it > out to see what would happen and it still does not resolve this issue. There > must be something somewhere happening because the numbers are rounded up and > they shouldn't be. > > I could probably write up a grid on a form and load it manually to see > whether it happens there as well. > > No other possible ideas as to what the issue for me might be? The only thing I can think of to diagnose the issue is to add this code to your bizobj: def afterRequery(self): print self.getDataSet(flds=['MyDecimalColumnName']) ...where, of course, you substitute the actual name of the column (or columns) whose value you want to check. When you run the form and it queries the database, this will print out the data that it gets from the database before any of the UI elements such as the grid can manipulate it. If the data here is rounded, then the problem lies in the database; if it has the full precision you expected, then the problem in in the grid. -- Ed Leafe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected] ________________________________ CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/3eb5c64f2911f841a886ac1d5ea8c356bb2...@041-db3mpn1-025.041d.mgd.msft.net
