Re: Inserting a record

[email@xxxxxxxxxxxxxxxxxxx (James W Kilgore)]

Booth,

For a threaded e-mail type of note, the notes record would have a unique
id number and a "refers to" id number.

Original notes would have blanks/zeros/null in the "refers to".

I would have two logicals to this file, those without and those with a
"refers to".

As you process the notes file, you would start with the entries without
a "refers to" value.  For each entry processed, you would enter a loop
to display the subordinate notes associated with the original.

Naturally, each subordinate note could have it's own set of
subordinates, and so on.  Recursion comes in handy.

For assigning unique id numbers, any number of techniques could work.  I
prefer all actual writes to be done via a data queue driven job.  The
display program submits to the queue and the queue job assigns the
number and does the write.

HTH

James W. Kilgore
email@James-W-Kilgore.com



boothm@ibm.net wrote:
> 

> 
> In other words, I'd like to do something like threaded e-mail.
> 
> One problem though has to do with updating the thread while someone else
> is looking or updating the thread at the same time.
>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---