How are you getting the value from the remote database? You need to find out where it loses the precision.
the code to pull the data back from SQL Server (using the RemoteDatebaseConnector) is:
SELECT SUM(ivd_amount) FROM InvoiceDetails INNER JOIN Invoices ON ivd_invfk = inv_pk WHERE inv_awbfk = awb_pk) AS InvoiceTotal
and this is how I put it into the SQLite database:
m.Put("inv_amount", records(result.Columns.Get("InvoiceTotal")))
At that point the value going in is still 19303.99
When I then query the SQLite database like this:
Invoices = DBUtils.ExecuteMemoryTable(SQLLite, "SELECT awb_number, pay_type, pay_amount, inv_amount, rnd_pk FROM RunSheetDetails LEFT JOIN Payments ON rnd_pk = pay_rndfk INNER JOIN DeliveryHistory ON rnd_pk = DeliveryHistory.del_rndfk AND del_delivered = 'True' WHERE cus_number = ?", Array As String(CustomerNumber), 0)
The value in the debugger is 19304 (0x4B68)
So it is either losing the precision when I put it into the SQLite database or when I get it back from it.