IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { Long taxId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); PurchaseInvoiceTaxLine sit;
query = query.replace(":ITSOWNER", pItsOwner.getItsId().toString()); String[] columns = new String[]{"SUBTOTAL", "TOTALTAXES"}; Double[] totals = getSrvDatabase().evalDoubleResults(query, columns); if (totals[0] == null) { totals[0] = 0d;