>Is there anyway to get at the text stored in the diary? _diarydate allows us access to the date but nowhere do I see where we can at the diary?
>
>Thanks!
>
Dick,

The diary record are stored in foxuser.dbf in the records with Type="DATA" and ID="DIARYDATA". The diary date is in Name field and text is in Data field.

USE (SET("RESOURCE",1)) AGAIN ALIAS rf
SELECT data FROM rf ;
  WHERE id = "DIARYDATA" ;
	AND Name = DTOS(_diarydate) ;
  INTO CURSOR crsDiary
* OR
SELECT LEFT(name,8) AS cDate, Data AS DiaryText ;
	FROM rf ;
	WHERE id = "DIARYDATA"