I’m not sure where to begin or what to do…I am working with a SQL developer. There is a Notes client application and a SQL application. The Notes app goes through a workflow and when it’s finished the SQL server makes a connection and pulls all the data. Then it populates one field in the Notes doc with a sequence number or the word ERROR. This all works very nicely. But I noticed it messes up a bunch of the Notes computed fields.
For example my edit history subform which has fields that keep appending values loses all of the values except the first line. Sample code for computed dateHistory field:
modified := @Text(@Now ; “D0T1”) ;
howMany := @Elements(statusHistory) ;
@If(@IsDocBeingSaved;
@Subset(dateHistory : @Trim(modified) ; howMany);
@Trim(dateHistory))
Also a field, Comments which gets set via a dialog box and can contain a lot of information (but is not a multi-value field but appends multiple values) will lose all data except the first line. Computed field named comments contains the value:
comments
Also computed fields that pull from a very frequently changing keyword list so I only want the fields to refresh at certain times. These fields also lose everything but their first value. Sample code for computed networkD field:
value := @Trim(networkNY : networkTH : networkTO : notInList) ;
@If(@IsNewDoc | status = “Draft” ;
value ;
networkD)
I have no idea why SQL might be truncating values of fields. Does anyone have thoughts on this? Desperate… TIA