Solved

@error in computed field

Posted on 2002-06-27
12
216 Views
Last Modified: 2013-12-18
Hi,

I have a field in a form that is computed.  The number id placed in this field is the next consecutive no.  This is now not working and @error is being placed where the id no. should go.
Any ideas?
0
Comment
Question by:Lucret
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 2
12 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 7114211
What is the formula and field type ?

Probably you are substituting text with number data type, or the dblookups can cause this kind of problem.

So be specific.

~Hemanth
0
 
LVL 1

Author Comment

by:Lucret
ID: 7114269
Type : number computed
Can't find the formula, where do I find that I'm looking in designer

0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 7114347
check the default value of the field
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:Arunkumar
ID: 7114750
Hi Lucret...

Select the Field and select from the menu : View - Programmers Pane.  You will now be able to see two new panes.

The Left pane would read  "Value" , "Options" , "Declarations" , "Intialize" and "Terminate" as its a computed field.

Select the "Value" and you should see the formula in the second pane to the right side of this pane.

Also, I suspect that this has a @DBColumn Formula for next number generation, that might have exceeded the limit and thats why an @Error is raised...

Let us know how we could help you!

-Arun.
0
 
LVL 1

Author Comment

by:Lucret
ID: 7115782
When I select value all thats there is TRFNumber could this be referencing something else
0
 
LVL 1

Author Comment

by:Lucret
ID: 7115843
else where in the form there is an ID field with a value of @Text(@DocumentUniqueID)could this be related
0
 
LVL 9

Expert Comment

by:Arunkumar
ID: 7116074
The TRFNumber should be the name of the field itself or referring to another field.  Check if you have another field of that name.  Whats this fields name ?
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 200 total points
ID: 7116510
The problem could be in the TRFNumber field formula. Similar to this field check its field value for formula.

0
 
LVL 1

Author Comment

by:Lucret
ID: 7143278
Hi,

the problem was that the document defore the error occurred was corrupted
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 7143428
Not my fault ;-)
0
 
LVL 1

Author Comment

by:Lucret
ID: 7143503
SOUND
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 7143600
And who is this Sound ?
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question