>I have to write a procedure to compare our customer file every night to the same file from the night before. Is there a file compare function in Fox or has someone written one that will allow me to quickly compare the two files. I'm looking for address changes to this customer file and do not have access to the table structures or the program so I have to look for these changes after they occur programatically. I think if I look field by field for differences in the text, once this file gets large, this will take forever.
>
>Thanks,
>
>Jill

Jill, the files in question should have a timestamp field that allows you to easily track changes. If the file is in a dbc, this is easy:

Create a function in your stored procedures called TimeStamp

FUNCTION TimeStamp
REPLACE TimeStamp WITH DATETIME()
RETURN
ENDFUNC

Then add a field to the table in question called timestamp, and put

TimeStamp()

in that table's record validation rule.