Solved

@error in computed field

Posted on 2002-06-27
12
214 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
  • 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mobile Iron iphone stop receiving new mails 6 1,314
Add a cc field to email code 3 111
Lotus Domino server 9 7 79
Split Domain with Lotus Domino and Zimbra mail server. 5 142
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
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.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

821 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