Last Record Update Time?

Bruce Easton bruce at stn.com
Wed Dec 12 08:27:45 PST 2007


Joe Chasan Wednesday, December 12, 2007 10:24 AM:
>
> On Wed, Dec 12, 2007 at 09:37:45AM -0500, Walter Vaughan wrote:
> > Larry S. Weaver Jr. wrote:
> > 
> > >>>I know that @ud gives the date a record was last updated.  
> Is there a 
> > >>>(perhaps undocumented) system maintained variable containing 
> the time a 
> > >>>record was last updated?
> > >>>      
> > >>>
> > >Anybody think it's worth a wish list item?
> > >  
> > >
> > While there is unused bits in the record header, I don't think 
> there are 
> > enough bits to hold a time stamp.
> > Do you think fp6.0 should use different file formats would be the 
> > primary question to solve.
> 
> @bd having to mess with @ub instead of having corresponding @bb
> @cd with no creation time
> @ud with no update time
> @bd with no "batch" update time
> file user edit limit
> 
> All items that have been asked for many times over the years that 
> wont' fit 
> in whatever is remaining in the few unused bits of the record header - i 
> think its time to break with the old and add some functionality that has 
> been asked for for years.  
> 
> > And even then to what resolution? MySQL holds resolution to 1 second, 
> > while postgreSQL holds it to a thousanth, MS-SQL is 1/300th of 
> a second, 
> > and Oracle is configurable AFAICT.
> > 
> > I've been working with systems lately that break in MySQL 
> because of one 
> > second resolution...
> 
> that's ken's headache, once we beat fp-tech over the head with a stick to
> convince them feature is worth having to begin with.  
>  

I prefer to store create/udpate dates, times and operator IDs in 
real fields.  I just find it provides flexibility.  Functionally, 
with stored fields I can tailor these kinds of fields to more 
closely match the way in which I think the data may be analyzed. 

For instance, when I see the lack of a last batch update time, 
I know that what I would really like is a specific field that 
shows when a particular posting process had hit a record, regardless 
of other output processes that may have hit the record (i.e., that 
may have been designed by someone else, writes the record for 
some other purpose), ergo the need for a specific store field 
to track my specific.  We've all probably had to, at one time 
or another, add that type of field to a file - like "Last 
Purchase Date".   So why not store all fields that may be needed 
for an application that may or may not now have a less 
meaningful counterpart in fp's sys-maintained fields?

Plus, if someone gets to your application data and archives it 
in a brute-force manner - poof!

Now if filepro is not meeting your requirements regarding 
precision for times, that's another matter that to me 
seems unrelated to relying on a set of system-provided 
fields.

Bruce

Bruce Easton
STN, Inc.






More information about the Filepro-list mailing list