System date behavior wish (GRX)
Chris Sellitto
sellich at guaranteedreturns.com
Mon Feb 12 13:26:19 PST 2007
> -----Original Message-----
> From:
> filepro-list-bounces+sellich=guaranteedreturns.com at lists.celestial.com
> [mailto:filepro-list-bounces+sellich=guaranteedreturns.com at lis
> ts.celesti
> al.com]On Behalf Of Bob Stockler
> Sent: Monday, February 12, 2007 12:55 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: System date behavior wish (GRX)
>
>
> Chris Sellitto wrote (on Mon, Feb 12, 2007 at 09:19:45AM -0500):
>
> | I don't know (or remember) if this topic has been broached in the
> | past, but here goes. I was wondering how difficult it would be to
> | have the @system date fields retain their values upon copying new
> | records. I know it would be just as easy carrying a date field on
> | the record, but I feel this is an inefficient way of doing things,
> | not to mention a waste of field space. We archive our data here on
> | a regular basis, and having this option would be great. Maybe have
> | a new flag on the copy command that would instruct filePro to
> | retain its system dates (@cd, @ud, @bd).
>
> A Work-A-Round until you get your wish . . .
>
> Creat two Alien filePro Files, one with its "real file" the "key"
> file from which you're archiving, the other's "real file" being
> the "key" file of the file to which you're archiving.
>
> The file layouts (map files) would have field #1 length 20, edit *,
> for filePro's info, with the rest of the map similar to the fields
> in the source and destination files.
>
> Do your archiving using these Alien files.
>
> Copy the record to be archived, intact, from the source file to
> the archive file (binary filePro File I/0 is good for this).
>
> Make all characters in Field #1 of the source file record be equal
> to chr("0") (ie: NUL), then make all characters in the balance of
> that record be equal to " ") (ie: Space), then write it.
>
> Run "freechain" on the source file. Presumeably, you'll be archiving
> only active (used) records, so it's not necessary to run "freechain"
> on the archive file.
>
> The result will be that @cb, @ub, @cd, @ud, and @bd are preserved
> with their original values in your archive file.
>
> Bob
>
> --
> Bob Stockler +-+ bob at trebor.iglou.com +-+
Thanks Bob, for your method. Although, I think I still may wait for a new filePro feature.
Chris
More information about the Filepro-list
mailing list