Archive

Archive for the ‘Lotus Notes Solution’ Category

Check Lotus Notes Arrays Equal

In a recent project, we had the need to compare two arrays to see if all the elements in one array were in the other array and vice versa. The elements didn’t have to appear in the same order in the arrays to be equal. So that prompted a generic “AreArraysEqual” function.
Read more…

Viewed 6397 times by 1957 viewers

Lotus Notes Decode Web URL

Although we have heard of an @-function that will decode a URL, but it is undocumentend at this time. In the mean time, here is a generic LotusScript function that will decode any URL.

Update: We have been made aware that the older version of this function did not handle Unicode characters. They are encoded with a “%u” prefix and include 4 hex characters after the “%u”. The version below supports Unicode characters.
Read more…

Viewed 7726 times by 1920 viewers

How to Show Notes API Error

When you do as much work with the Notes API as we do, you’ll end up running into errors at one point or another. When writing programs in C or C++, you can translate the error number to a string pretty easily. But we’re doing more and more with the API in LotusScriptand have many more examples). In this situation, we needed to be able to translate an error number into a text error message.

Read more…

Viewed 4322 times by 1116 viewers

FailSilent Keyword In Lookups in Lotus Notes

we weren’t aware of the great new feature added to the @DbLookup function in Notes. The @DbLookup function now has an optional parameter at the end. This parameter takes one or more keywords in a list. I’ll describe these by showing an example.

Read more…

Viewed 6118 times by 1513 viewers

Removing Invalid Subordinate Keyword Values in Lotus Notes Field

I know the title of this tip doesn’t mean much. But I couldn’t come up with a meaningful title in just a few words. So let me describe the situation. Let’s say you have a multi-value keyword fields that contains state names. And another multi-value keyword field that contains city names. The choices for the city names come from the selected state names. If you choose some cities, and then go back and remove a state, how do you eliminate those selected cities that are no longer choices?
Read more…

Viewed 6537 times by 1913 viewers

What Makes A Good Lotus Notes Password?

There has been a lot of talk around the office lately about passwords and what’s the definition of a “good” password. Obviously, a password that can’t be broken is a “good” password. But there’s a trade-off between passwords that are easy to remember and passwords that are difficult to break. Let me describe a couple ways to create “good” passwords.
Read more…

Viewed 3879 times by 1044 viewers

Refresh Lotus Notes Parent document When Closing Child document

During development of a new application, we ran across a situation that I’m sure some of you have seen. We have a parent document and children documents. The children are only displayed in an embedded view in the parent document. So, when you open up the parent, you see an embedded view with “show single category” enabled that shows all the children of that parent. Those children don’t show up in any other view, so you must open up the parent to see them. There’s buttons in the parent to create a child, edit a child, delete a child, etc.
Read more…

Viewed 7231 times by 2153 viewers

Check an RTF Lotus Notes Field is empty

This interesting workaround comes It does cause a little bit of UI flicker, but works on the front-end and back-end:
Function IsRTFNull(rtfield As String) As Integer

‘This function tests a Rich Text field to see whether or not it is null. It returns TRUE if the field is null, and
‘returns FALSE if the field is not null. It works even if the rich text field contains a file attachment,
‘doclink, or OLE object but does not contain any text.
Read more…

Viewed 6543 times by 2019 viewers

Lotus Notes Richtext field checking Attachmentment or Size Without Saving document

Several threads cover the topic of preventing the attachment of overly large files to a Notes document, and one major hurdle seems to be how to do so without first saving the document, let alone without first attaching the file. Without covering all the reasons why this is a challenge, I thought it might be helpful for me to detail the solution that I came up with after reading several posts in this forum and piecing everything together.
Read more…

Viewed 7819 times by 2649 viewers

Lotus Notes Embedded View – Play with selected document

We have many way to use Lotus Notes Embedded View in form for user can easy to use doc child. Let’s say that you for some reason have a form with an embedded view that lists a bunch of documents. You would like to mark one of the documents in the embedded view and get a grip of this document and do something with it. This is how I have solved it (with some help form the IBM developerWorks forums).

Read more…

Viewed 7335 times by 2257 viewers