From d74adcbb159280be962918125d20ec8ac67a3f93 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Sun, 3 Jul 2022 15:31:24 +0800
Subject: ref #65, new formula function: DGET

---
 calc.go | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

(limited to 'calc.go')

diff --git a/calc.go b/calc.go
index 25c2e18..83885dc 100644
--- a/calc.go
+++ b/calc.go
@@ -433,6 +433,7 @@ type formulaFuncs struct {
 //    DEGREES
 //    DELTA
 //    DEVSQ
+//    DGET
 //    DISC
 //    DMAX
 //    DMIN
@@ -18173,6 +18174,32 @@ func (fn *formulaFuncs) DCOUNTA(argsList *list.List) formulaArg {
 	return fn.dcount("DCOUNTA", argsList)
 }
 
+// DGET function returns a single value from a column of a database. The record
+// is selected via a set of one or more user-specified criteria. The syntax of
+// the function is:
+//
+//    DGET(database,field,criteria)
+//
+func (fn *formulaFuncs) DGET(argsList *list.List) formulaArg {
+	if argsList.Len() != 3 {
+		return newErrorFormulaArg(formulaErrorVALUE, "DGET requires 3 arguments")
+	}
+	database := argsList.Front().Value.(formulaArg)
+	field := argsList.Front().Next().Value.(formulaArg)
+	criteria := argsList.Back().Value.(formulaArg)
+	db := newCalcDatabase(database, field, criteria)
+	if db == nil {
+		return newErrorFormulaArg(formulaErrorVALUE, formulaErrorVALUE)
+	}
+	value := newErrorFormulaArg(formulaErrorVALUE, formulaErrorVALUE)
+	if db.next() {
+		if value = db.value(); db.next() {
+			return newErrorFormulaArg(formulaErrorNUM, formulaErrorNUM)
+		}
+	}
+	return value
+}
+
 // DMAX function finds the maximum value in a field (column) in a database for
 // selected records only. The records to be included in the calculation are
 // defined by a set of one or more user-specified criteria. The syntax of the
-- 
cgit v1.2.1