Hello,
I have a VB6 program which uses COM to add appointment to Lotus Notes. The program was developed for Lotus Notes 5.0. When I attempted to use it with Lotus Notes 6.0 the ComputeWithForm method gets ‘Incorrect data type for operator or @Function: Number expected’. How can I determine what is causing this?
Thanks,
Michael Stoler
Subject: ComputeWithForm failing
I am struggling with the same problem when upgrading my C++ program to set Calendar Items for Lotus Notes 6.0.
Did you find the cause of the error?
Subject: ComputeWithForm failing
You have a problem with a formula in a field. I would be looking for a function where a numeric field contains text or a number and a string are attempting to be added together.
Start by checking all Input Translation formulas and then Validation formulas.
Subject: RE: ComputeWithForm failing
Is there a way to have ComputeWithForm tell you what is failing?
Subject: RE: ComputeWithForm failing
Not that I know of!
Subject: RE: ComputeWithForm failing
However, if you open the document in your Notes client and press F9, I believe it’ll tell you what field it had an error in.
Alternately you can narrow down the position of the erroneous field by placing a field with a known error on the form (e.g. with formula 7/0) and see which error you get, your current one or division by zero. If it’s division by zero, move it further down the form, else move it up. This should let you zero in on the bad old field.
Subject: RE: ComputeWithForm failing
I have the same issue trying to determine where an “…incorrect data type error: Number expected” is originating from, but mine has a twist.
The error only occurs on a ComputeWithForm() and not on a document refresh (F9 while in edit mode).
To make sure its nothing in my LotusScript that causes the error, I placed the ComputeWithForm() call in the QueryOpen event…I get the error. I go into edit mode and hit F9… no error.
Argggh!
I could set the second param to False, but I would rather solve the mystery.