![]() And wouldn't you know it, the tool was retrieving the value into a single-precision float variable! (Delphi was already pretty dated even when this happened around 2007, and this was written in some old version like Delphi 4.) So I cracked open the code that handled dumping the results to Excel, and found a case statement that would deposit cell values into Excel based on the data type of the column retrieved from the query. Perhaps just as miraculously, I also managed to find the installation media for the version of Delphi it was built in. Miraculously, I was able to dig up the source code for the report tool in some alcove of our IT file share. The question of why still remained, though. We quickly isolated a single check in the output that was showing the wrong total when run with our reporter. ![]() And yet running the SQL query manually produced the correct results. This had been used for a number of years, but one day, it was suddenly off by about 2-3ยข. do our cleared checks match the ones we think we wrote?) ![]() The AP head would run this periodically - monthly, I think - and upload this list to the bank, as a means of fraud detection. One of the accounting reports would simply list all the AP checks from our ERP system. We had a ton of reports for this thing, and it was used by sales, purchasing, accounting, management, etc. It was just a simple Delphi program, written well before my hire date, that could run text files containing a report definition (really no more than a title, an ODBC data source name, and an SQL query), and dump the reports to Excel, slowly, via COM. We used to have this really old "report" program at work. Or do even the most conservative and OCD of the bean counters find 10 digits and scientific notation sufficiently accurate for noodling out such enormous sums ? Would 20 digit precision be sufficient (assuming accurate algorithms coded into the machine) for computing the debits and credits of a really large pension system, perhaps handling 10s of trillions coming in and going out over the next 30 to 50 years ? (05-05-2015 11:22 PM)TASP Wrote: Don't mean to derail the topic, but with really enormous numbers being used in the government and media in descriptions of large financial deals and policies, is there a need behind the scenes for the actual 'bean counters' to have access to machines with greater precision than we typically see with our HPs ?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |