Last modified

[Walter D Vaughan Jr]

> > -----Original Message-----
> > From: Filepro-list [mailto:filepro-list-
> > bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf
> > bounces+Of
> > Mike Fedkiw via Filepro-list
> > Sent: Tuesday, September 23, 2014 3:02 PM
> > To: Filepro list
> > Subject: Last modified
if there is a system field that
> > contains the last modified date and time. Even if they works, I still
> > have to think about how it will know if there's and new items within the
> inventory file.
> >
> > If anyone has any ideas, I'm open to trying just about anything.
> >
> > Thanks, Mike
> 
> System maintained fields:
>  @ud contains the date of last update
>  @cd contains the date the record was created

[Walter D Vaughan Jr] 
@BD (batch date) because you could have that row of data changed by code and
not human UX as well.

Of course all of this is not general enough because it does not deal with
deleted rows either.

What about using a different storage engine instead of native filePro?
http://www.fptech.com/Products/Docs/fpmanhtm/Filepro/MySQL_Interface.htm

One could have triggers to store timestamps that would not require any code
in filePro generate. 

Things were easier in the 1980's when all we had was our trusty Tandy 16B
and a few Dt-100's and expectations were much lower.