Last Record Update Time?

[Joe Chasan]

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.  
 
--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan-                      Magnatech Business Systems, Inc.
joe at magnatechonline.com           Hicksville, NY - USA
http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264