Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

@error in computed field

Posted on 2002-06-27
12
Medium Priority
?
232 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 400 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] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

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.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

824 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