lastchange

[paulvdwa]

Hello all,

I have a table with the following fields:
name C
biography M
lastchange D

I'm using a form to view the name and the biography, every time I change something to the name or the biography, the lastchange field must be filled with date(), when I'm just looking to the name without changing the name and/or biography, lastchange may not be adapted.
How manage it?

regards

Paul

 

[Mike Lewis]

Paul,

Is the table buffered? If so, add this code immediately before the TABLEUPDATE():

* assuming the relevant table is in the 
* current work area
IF Name <> ODLVAL("Name") OR ;
  Biography <> OLDVAL("Biography")
 
    REPLACE LastChange WITH DATE()

ENDIF

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[DSummZZZ]

If it's not buffered and you have a 'Save' button, just add similar code to the 'Save' button.

If there is no 'Save' button, maybe add the code to the controls' LostFocus event.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm