April 28, 200421 yr 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?
April 28, 200421 yr 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.
April 28, 200421 yr Author 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.
Create an account or sign in to comment