**

Hi Axton,

I was surfing the web looking for info on how to write a direct SQL to a diary field.  Is this possible.  I created a custom diary field.  When a user presses a button the SQL statement appends the info within a column in the database to the last entry.  Is this possible?  When I set the field with the SQL statement  -- the user's data is not sent directly to the diary field.

I came across your article on the web.  Do you have any idea if a SQL can directly send info into the worklog/and append more info later.

 

Re: Duplicate Entries in Diary Field
by Axton

Reply to author Reply to group

 
It is active links that read the contents of a diary back into the  
diary field when opened as a dialog.  Subsequent saves cause the  
entire contents of the diary to be rewritten.  Be careful with this  
becuase if the size of the text exceeds 1bm and the Oracle-Max-Text  
size (or whatever it is called) is not set to a value greated than  
1mb, your server will crash.  The workaround for this is to create a  
display only char field that is used for new diary entries and update  
the active links triggered when clicking the save button to push the  
char field contents to the diary instead of the old diary field  
contents.  I have a bug open with Remedy on this, but no resolution  
will ever be provided for the current release of the apps.  
 
Axton  
 
__20060125_______________________This posting was submitted with HTML in it___

Reply via email to