Solved

@error in computed field

Posted on 2002-06-27
12
222 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
Industry Leaders: 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

636 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