Varius problem with Date adjusting and FieldSetText and @Today - unsure what causes the problem

HCL Domino Domino Forum
1

Hi There

We have just upgraded the Domino server to R.6.5.2 and since then we have some problems in different databases. I have tried to troubleshoot, but this is not just simple issues.

  1. We have an database handling Out of Offices. The DB contains a form for this, and this form contains two fields - FromDate and ToDate.

  2. From a users point of view, what happens is this: User creates a new Out of Offices registration. This contains the FromDate and ToDate from the day selected in the calender view. When user is trying to select another eiter FromDate or ToDate, the two dates are changed to @Today, and they have to change them both.

Before the upgrade, the FromDate and the ToDate from the selected day where kept - as default also.

  1. From a designers point of view, what is happening is, that the user clicks to make a new. The PostOpen on the form sets the fields by the code:

Call Source.FieldSetText(“FromDate”, StartDateTime)

Call Source.FieldSetText(“ToDate”, StartDateTime)

where StartDateTime is set to: workspace.CurrentCalendarDateTime

The fields has @Today as default value.

  1. When debugging the script no errors occure and the fields are set correctly when creating. When looking closer into the debugging it seems like the FieldSetText do not set the doc.field, so the information is not kept.

  2. I have tried different things, and none of them worked - having the field “StartDateTime” on the form, saving the document, changing the default for the fields etc.

It seem to me like it has something to do with the upgrade and the way things are handled. I cannot defint what is handled differently, but I guess it has something to do with eiter FieldSetText on uidoc, handling of default values or something like that.

Please help me, if you can :smiley:

Charlotte

2

Subject: Varius problem with Date adjusting and FieldSetText and @Today - unsure what causes the problem

When you do a source.save, does the doc.field value become blank? I’m assuming you used the source.fieldgetext to get the field.

Can you duplicate the same on a simple test form with only the date fields? Perhaps something else is cleaning out the doc.field.

3

Subject: RE: Varius problem with Date adjusting and FieldSetText and @Today - unsure what causes the problem

After trying to move code to a different form, I have narrowed the problem down to concerning a Call uidoc.refresh

  1. I cannot make a uidoc.save since the fields changes values are therefore they are not alloved - hard to explain.

  2. Remember: This has worked before.

Any solution?

Thank you kindly

Charlotte

4

Subject: RE: Varius problem with Date adjusting and FieldSetText and @Today - unsure what causes the problem

When the uidoc.refresh, I’m guessing, this is where the fields loose their values. I ran into this not long ago and found no solution other than to save the doc first, then refresh and then save again before closing.

Hope this helps!

5

Subject: RE: Varius problem with Date adjusting and FieldSetText and @Today - unsure what causes the problem

Do you remember WHY you ran into this problem? Is it related to a 6.5.2 update?

Charlotte

6

Subject: Can’t explain why? Sorry!