Jump to content

TRUE ≠ 1 and odd behaviour after import


This topic is 2748 days old. Please don't post here. Open a new topic instead.

Recommended Posts

LS,

Maybe this is well known, but couldn't find post about it.

---

So a client of mine had a database crash. I recovered the database ( 7GB ) and imported the data into a clone of a backup.
There is a relationship of any  to multiple between two tables, eg. link_all (  value : 1 ) and a field called active_link with this calculation 

Status= "On Hold" or Status="Active" or Status="Booking" ( result : number ) ( this is a boolean result )

For some strange reason the imported data continued to behave like they always did, eg. the result of this calculation was 1. ( field value : Active )

All records created after the import had no value  ( field value : Active ).

The fix was easy : 

case (  Status= "On Hold" or Status="Active" or Status="Booking" ; 1 )

The question remains  : why is FM changing is behaviour all of a certain with only new records ? 

Kind regards,

Joost

Link to comment
Share on other sites

This topic is 2748 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.