TR will give you the current diary entry (which is null if no changes to the diary field). If you want the last entry, you have to store it somewhere else (character field as you mentioned) or parse the diary field (which is tricky). I would make the char field < 4k characters so it does not add a clob to the table (text for sql, not sure the cutoff in chars), then use the LEFTC function to only grab the first 4k chars of the diary entry.
Axton Grams Sueli Kanegae wrote: > Hi List, > > I need to know the last entry in a Diary field and was taking a look at old > exchanged messages. I´ve found a solution below but couldn´t do the Set > Field: > "Most Recent Action" > 'TR.Work Diary' > I also tried '$TR.Work diary$', but it doesn´t work. > > Any other idea to save just the last entry (diary field)in a character > field? (I don´t need odbc drivers or crystal as Carina does) > > Thanks in advance! > Sueli > > > On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG > <[EMAIL PROTECTED]> wrote: > >> Make a field called "Most Recent Action" (Field Size = 0 or whatever you >> feel is appropriate to catch the last diary entry). Create a filter that >> fires on >> 'TR.Work Diary' != $NULL$. >> >> Do a set fields "Most Recent Action" := 'TR.Work Diary'. Then you can >> report on that field instead of the work diary. >> >> Thanks, >> Claire >> -----Original Message----- >> From: Carina Burns [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, June 15, 2004 1:32 PM >> To: ARSLIST@ARSLIST.ORG >> Subject: Diary Field Question >> >> Listers, >> With the user preference form, you can set the diary field to display the >> most recent entry first. While this works through the forms (whether web >> or client,) it doesn't work when using the odbc drivers and crystal >> reports -despite using an id with the diary preference set. The first >> entry is displayed rather than the last entry. Has anyone out there found >> a way to retrieve only the last entry or to specify the display order of >> the diary entries within a crystal report? >> >> Much Appreciated, >> >> Carina Burns >> Database Admin >> Richardson ISD >> [EMAIL PROTECTED] >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
