Solved

@error in computed field

Posted on 2002-06-27
12
215 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
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…

820 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