Tracy,

As far as I know, the timestamp is the time when the particular record was
last modified. The value is documented following the routine as it is
described in foxpro ffc\_FrxCursor.vcx.

I do not know whether it may help, but I did an experiment analyzing the scx
files datetime and the maximum timestamp value in each, and here is the
statistics.

121 scx files
46 timestamps = scxfile datetime
51 timestamps exceed the scxfile datetime by 1 hour, which I think is somehow related to 1-hour time adjustments we make twice per year
24 timestamps dates # scxfile dates

So, about 80% of the files have the timestamp synchronized with the file datetime.

Here is the routine, if you wish:

CLEAR
CLOSE TABLES all
SET HOURS TO 24
ADIR(aa,"*.scx")
ok=0
onehour=0
oFrxCursor = NEWOBJECT("FrxCursor", HOME()+"ffc\_FrxCursor")
FOR ia=1 TO ALEN(aa,1)
  SELECT MAX(timestamp) timestamp FROM (aa[ia,1]) INTO CURSOR yy
  DO case
  case oFrxCursor.GetTimeStampString(yy.timestamp) = DTOC(aa[ia,3])+" "+aa[ia,4]
		?aa[ia,1], oFrxCursor.GetTimeStampString(yy.timestamp), aa[ia,3],aa[ia,4]
		ok=ok+1
  CASE TTOD(CTOt(oFrxCursor.GetTimeStampString(yy.timestamp)))=aa[ia,3] and;
	        hour(CTOT(oFrxCursor.GetTimeStampString(yy.timestamp)))- ;
                                                    HOUR(CTOT(aa[ia,4]))=1
		onehour=onehour+1
  endcase
ENDFOR

oFrxCursor=null
?ALEN(aa,1), ok, onehour, ALEN(aa,1)-ok -onehour
RETURN

>I know it would be the same as the exe itself, but there is no way to determine what the last modified date of the form was directly before it was changed due to the compile of the exe (if recompile all done), right ?
>
>
>
>Thanks Yuri. I see the timestamp field, but each record has a separate timestamp and the comment records have none. Not sure which record to look at for the form's timestamp. Or is that value set in the 1st record when a form is compiled?
>
>I thought there was a way to get it from the exe or from the form itself at runtime. I don't remember now so I have no idea how I did it before.
>
>
>
>>Hi Tracy,
>>
>>Here is just an idea.
>>There is a timestamp field in form.scx table. If you are able to extract the form from exe (you may try something like yrecover.exe here in the download section), then the latest timestamp value in the form table may give you the information you need.
>>
>>
>>>Is there anyway to determine the datetime of a form that is compiled into an exe? Does any form property contain that? If I build an exe on 7/1/2007 and when the exe is compiled, the form 'myform' has a last modified date of 6/30/2007, is that information stored anywhere in the exe or in the form properties? Not from the file on disk, but from the form itself during runtime (the form won't exist on disk)...