DLookup('field', 'table', ['condition'])

Hi,

I'm trying to create Domain Aggregate function that mimic Access' Dlookup
function, but without any luck, after digging (i think) all the docs
don't have the solution yet.

Syntax:

DLookup ('field', 'table|view', ['condition'])

where:
field -- column name or calculation
table|view --
condition (optional) -- SQL WHERE condition without the
WHERE keyword

If the query returns multiple rows then it will only get the
topmost column.
If the query retuns 0 rows then NULL would be returned

An example argument to the function would be

DLookup ('id', 'student', 'name=\'Bill Gates\'') --> '2001-432'

For now, I use some workaround for this, and it would be easier for me if
this function is present.

Hope u guys can help ;). Thank u in advance

Herbert

--

MSU - Iligan Institute of Technology
Iligan City, Philippines