Re: Getting the field attributes of a subfile record

Buck Calabro/commsoft wrote:

> On 02/06/99 10:29:10 PM Bob Larkin  wrote:
>
> >OK everybody, please don't shoot, but I think we need to look at this a
> >different way.
> >(Disclaimer - Worked 60 hrs this week, plus selling a house, and house
> hunting,
> >so maybe my brain is mush.)
>
> >Problem.
> >      Record is in error, or RI would not be on in the first place. So if
> the
> >record is in error,
> >      it should be read and re-validated every time the subfile is
> processed. If
> >on the other hand,
> >      the RI is indicating a non-error condition, then the record should
> not be
> >read unless it is
> >      changed.
>
> This isn't always the case.  Take the example of highlighting a line as an
> eye-catcher, like an invoice with an item having a large quantity.  This
> may not be an error, but we want to draw the user's attention to it.
>
> >Solution.
> >       Use the SFLNXTCHG keyword., and use READC to only read the subfile
> >records
> >that have
> >       changed. If a record fails validation, you can specify SFLNXTCHG on
> the
> >record, which
> >       will cause the record to appear to be changed, even if the user did
> not
> >modify it.
>
> This makes a lot of sense, but sometimes it's easier to spin through all
> the subfile records than it is to read only the changed ones.  Let's say
> you're trying to total up a list of debits and credits and want them to
> balance, or perhaps you have some special requirements for an invoice
> whereby you can't mix electronic and agricultural items on the same order
> due to cost centre restrictions.  Finally, a record can be valid when the
> transaction begins, but become invalid before the transaction is complete.
> Take the example of an item selling out of stock before THIS invoice is
> completed.  None of these objections are impossible to overcome, but it can
> get uglier with SFLNXTCHG.
>
> otoh, SFLNXTCHG offers better program response if using a big subfile
> (imagine reading 2000 records rather than the one that changed)
>
> Buck Calabro

Buck,
Thanks for being gentle.
Bob

begin:          vcard
fn:             Bob Larkin
n:              Larkin;Bob
org:            <A HREF="HTTP://web.wt.net/~blarkin/">Larkin Computer Consulting</A>
adr:            <A HREF="http://web.wt.net/~blarkin/">Bob and Diana's Page</A>;;;Houston;TX;<A HREF="http://web.wt.net/~blarkin/">;United States
email;internet: blarkin@wt.net
title:          Systems Consultant
x-mozilla-cpt:  ;4104
x-mozilla-html: FALSE
version:        2.1
end:            vcard