Where do I find the code that actually loads the dataset with data from the db itself? I traced things back to this line:
self.DataSet = self.DataSetFunction() but cannot see where or how the data is loaded. I would like to trace this out as I did some quick tests in straight python and am able to see the data from my db the way I see it elsewhere so I surmise something is amiss here. Thanks, Tom ________________________________________ From: [email protected] [[email protected]] on behalf of RUSSELL Thomas Sent: Tuesday, May 01, 2012 8:41 AM To: Dabo Users list Subject: Re: [dabo-users] Precision Value in Grid Column 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 ________________________________ 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
