🚀 go-pugleaf

On Fri, 17 Apr 1998 23:21:45 +0200, "Ole Willy Tuv" <owtuv@online.no>
wrote:

>In present version OODML seems somewhat limited in functionality compared to
>DML. For example, the ROWSET lacks methods equivalent to SCAN and
>KEYMATCH(). Sometimes there is a workaround, usually involving more code,
>sometimes there isn't.

Ole Willy Tuv,

I'm finding, sometimes, that the need for additional code is actually
a benefit. That is, I have additional control over things that I
didn't have when a single function did more things (than maybe I
wanted it to).

In case you weren't aware, the 'work arounds' for Scan and Keymatch()
seem easy:

Scan:

  for n = 1 to form.rowset.count()
    <do stuff>
  next

Keymatch():

Just open a second query of the same table with the appropriate
indexName:

  this.query_working_table = new query()
  ...

 this.query_lookup_table = new query()
  ...
  with(this.query_lookup_table.rowset)
    indexName = '<tag>'
  endwith

Then use the second query's rowset just like you would have with
Keymatch():

  if form.query_lookup_table.rowset.findKey(upper(<entryfield value>))
    <alert duplicate record>
  else
    <save data>
  endif

Ned