Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 325 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
The definition of the field...
Fisherman
Member Posts: 456
Very strange behavior here.
I've made an update to a custom table in our database. It now contains a boolean flow field that uses an EXIST() CalcFormula.
Now, whenever I attempt to open the form that uses this table, I get the message
[Edit]
Thought I should mention - I am able to save and compile this form. This error only occurs at run time.
I've made an update to a custom table in our database. It now contains a boolean flow field that uses an EXIST() CalcFormula.
Now, whenever I attempt to open the form that uses this table, I get the message
--------------------------- Microsoft Dynamics NAV --------------------------- The definition of the field Validation Warnings Exist was changed after the object was saved. Old type: Boolean New type: Integer --------------------------- OK ---------------------------The weird part is... I haven't even put the checkbox on the form that is intended to display this flow field! I just tried to run the form, and it's throwing this error. Has anyone else seen this?
[Edit]
Thought I should mention - I am able to save and compile this form. This error only occurs at run time.
0
Answers
reopen your DB and try to open the form. that always works for me.
edit:
how is your exist working if the new type is integer? i thought exists would use boolean?
double check the table to make sure your field is setup properly.
Thanks for the quick reply, but no dice.
I just completely shut down NAV, logged out and back into my Terminal Server Session, and deleted my ZUP file before I reopened NAV. Same result.
This is actually the first time I've seen this error in 4 years of programming in NAV. Kind of bugging me because I'm on a timeline and don't really have time to recreate the form.
I'm thinking about exporting it, deleting it from the database, and then reimporting to see if that does any good.
The field in my table is called "Validation Warnings Exist" and is a boolean flowfield that points to a field in a child table called "Validation Warnings Count", which is actually also a flow field. That Flow Field (in the child) is an integer value. Validation Warnings Exist is calculated as true where the child record's "Validation Warnings Count" is > 0.
The table itself opens fine, and the flow fields calculate as expected. It's just the form that won't open...
It was actually a problem in my subform. I didn't have my head on straight for a moment.
Thanks!
Sorry, couldn't resist
RIS Plus, LLC