We value your feedback! Please click here to access our 2024 Client Survey. The survey will remain open until November 1st. Your perspective will help guide our product/service planning and goals for the upcoming year and beyond!
Hi
I'm having a very weird issue when using the updateRows or insertRows functions in the RLabkey package. when a number is between 1E-5 and 9.999E-5 they get inserted as 0. when the number is E-4 or E-6 they go in fine. My script is running using the R scripting engine in LabKey and posting to a sample table. please see the attached file for data and error log examples.
Is there a catch for E-5 numbers somewhere in the Rlabkey package? If I edit the field manually in Labkey it will accept the correct E-5 number.
Thank you for bringing this to our attention! You're right that there's a problem with Rlabkey and E-5 numbers. In my experimentation, there may also be precision issues with E-2, E-3, and E-4 numbers. I've opened an internal issue to track this: https://www.labkey.org/home/Developer/issues/issues-details.view?issueId=51160
In the meantime, if you're able to adjust your scripts to not use this notation, that's likely the quickest workaround.
E-5 inserting as 0.png