If your desire is to remove the deleted forms COMPLETELY from your forms
file this is a simple process.  You need to go to terminal specification
menu in formspec (select "T" on the main menu) and then press ENTER.  This
will force a total recompilation of the forms file, but will remove some, if
not all of the old trash forms.

Thanks Scott.
eXegeSys, Inc.
Phone: 801-538-0222
Fax: 801-538-0228
e-mail: [log in to unmask]


-----Original Message-----
From:   Cynthia Redick [mailto:[log in to unmask]]
Sent:   Thursday, May 07, 1998 8:32 AM
To:     [log in to unmask]
Subject:        "123199" in MM3000 Forms Files

My boss needs some help with physically deleting logical records in
formspec -
does anyone have any ideas?  Here at 3M Columbia, we have historically
used
'991231' as the 'end-of-time' for certain data fields, and we are
getting ready
to change this to '20271231', which prompts his need for help.  Thanks
in
advance for any suggestions for Bill.

Cynthia Redick
3M Columbia
---------------------- Forwarded by Cynthia P. Redick/HE-Columbia/3M/US
on
05/07/98 08:39 AM ---------------------------
From: Bill Thalhuber on 05/06/98 05:13 PM

To: Cynthia P. Redick/HE-Columbia/3M/US@3M-Corporate
cc:
Subject: "123199" in MM3000 Forms Files

Below is what prompted my telephone request to you.

---------------------- Forwarded by Bill Thalhuber/HE-Columbia/3M/US on
05/06/98 05:11 PM ---------------------------
From: Bill Thalhuber on 05/06/98 04:46 PM

To: Marcia Odom/HE-Columbia/3M/US@3M-Corporate
cc: Al Columbia C. Smith/HE-Columbia/3M/US@3M-Corporate
Subject: "123199" in MM3000 Forms Files

"123199" appears in the following MM3000 forms files forms:

Forms File      Form    Comment

MPSFORM.PUB.CLMM[TEST]  AddFOHdr
MPSFORM.PUB.CLMM[TEST]  AddFOType5
MPSFORM.PUB.CLMM[TEST]  BatchAddFOHdr
MPSFORM.PUB.CLMM[TEST]  AddFOLine
MPSFORM.PUB.CLMM[TEST]  ChgFOLine
MPSFORM.PUB.CLMM[TEST]  ChgFOLine2
MPSFORM.PUB.CLMM[TEST]  ChgFOLineX

ORDFORM.PUB.CLMM[TEST]  AddWOShop       no relevance to FOE end-of-time
ORDFORM.PUB.CLMM[TEST]  RevRecIss       no relevance to FOE end-of-time

I used Qedit with a List "123199" command to identify the forms.  As
forms
files are special, the results are ugly.

In the process I discovered that once deleted, a form's data remains in
the
forms file (even after the forms file has been compiled)!   To verify
this
phenomenon I added a new form, specially marked the form, deleted the
form,
compiled the forms file, and could still observe the form.