Database functions inside custom functions

[Harriet Bazley]

Is there some reason why I can't use database functions (e.g. dcounta(),
dsum()) on arrays passed to a custom function? Attempting to do so just
appears to cause PipeDream to crash. I can't find anything in the
documentation covering this one way or the other.

--
Harriet Bazley == Loyaulte me lie ==

Mate, this parrot wouldn't VOOM if you put four million volts through it!

[Alan Adams]

In message <b42e2a115...@bazleyfamily.co.uk>

Harriet Bazley <li...@bazleyfamily.co.uk> wrote:

> Is there some reason why I can't use database functions (e.g. dcounta(),
> dsum()) on arrays passed to a custom function? Attempting to do so just
> appears to cause PipeDream to crash. I can't find anything in the
> documentation covering this one way or the other.

A quick look in the printed manual describes arrays as having multiple
values in one slot. The dbase functions operate on a range of slots.

Page 13 continues:

"Another way of extracting elements of an array is to use set_value to
write out the array into a range of slots. For example if A1 contains an
array the set_value(d1e3,a1) will put the first two columns and 3 rows
into the slots from D1 to E3."

Does this help?

--
Alan Adams

[Harriet Bazley]

On 21 Apr 2025 as I do recall,

It might do. :-)

I have been working on manually scanning arrays as an alternative, and
discovered that Pipedream does not cope elegantly with attempting to
access array parameters inside a custom function with an index of
zero....

--
Harriet Bazley == Loyaulte me lie ==

You cannot propel yourself forward by patting yourself on the back.