Taking records out of focus?

Nancy Palmquist nlp at vss3.com
Thu Jul 7 13:07:55 PDT 2011


Stanley,

I might use a date instead of just a Y to indicate deleted.  It is more 
helpful and sorts/indexes better.

It is easy to exclude everything with a value in that field.  But what 
you are trying to do will require you take over all the browsing 
functions, think out your indexing - maybe.

You could also move them to a qualifier and then they could stand alone 
and still function if you need them.

Nancy

On 7/7/2011 4:32 AM, Stanley - stanlyn-com wrote:
> I'm trying to create a deletion recall routine in fp.  I need to create a
> field named "deleted" and when deleting the record I'm not really deleting
> it, instead I'm setting the field "deleted" to yes.  Now all records that
> has the "deleted" field set to yes becomes invisible to the system.  Note
> that when they are set as deleted, it still needs to be queryable so its
> value can be changed back to "Not Deleted".
>
>
>
> Any ideas on how I can do that?  BTW, this can be used in so many other non
> deleted ways, such as parsing in or out a certain defined set of records.
>
>
>
> Thanks, Stanley
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20110707/ef2c30f6/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-- 
Nancy Palmquist         MOS&  filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com



More information about the Filepro-list mailing list