Matt Klein Posted April 28, 2004 Posted April 28, 2004 I have a table that has a field call Constant which defined as a calculation with a calculation of "1". I have another field in the table called RecordID which is defined as a calculation with a calculation of "Get(RecordID)". When I import records into this table, unless the "Perform auto-enter options while importing" box is checked, these calculations do not occur so the fields are empty. This was not the case in FM6 and below. Any thoughts?
DrRoebuck Posted April 28, 2004 Posted April 28, 2004 Try setting the calculations as unstored. Open the calc field. Click Storage Options. Check the box for "Do not store calculation results ..." This would actually be necessary for your RecordID field to work properly. As for the Constant field, I'd suggest using a normal number field with an auto-enter value of "1". Though this would mean for importing you'd still have to check the "Perform auto-enter ..." box.
Matt Klein Posted April 28, 2004 Author Posted April 28, 2004 Sounds like something else I am going to have to break my habit of doing. Setting RecordID to unstored is not going to help me since I use that data in relationships. Previous versions of FM didn't have this problem. Not a big deal really. It's just that I'd rather not have lookups and auto-enters occur when importing data into a clone, but I do need the Constant and RecordID to calculate.
Recommended Posts
This topic is 7775 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 accountSign in
Already have an account? Sign in here.
Sign In Now