Append Record, Default Value

[John Fringer]

I have a table that has simple default value equations. If I append records to the table the default value equations don't work. Any suggestions ... I found a previous post, but no one answered it?

Thanks...John

[[email protected]]

John,
I'll take a stab at this. I'm new so I'm not sure but I think that the field rules do not get evaluated on import or append. You need to go to the table>utilities>recalculate calc fields (field rules). Let me know if that works.

Bill Belanger

[Stan Mathews]

Good idea but I don't think that will work.

The default values in the field rules are set up on the data entry tab. This suggests to me that they are meant to aid in speeding up hand keyed data entry.

I would look to modifying the append operation to "append" the default value (as set in the field rules) when the append is performed. This would be accomplished by specifying another line in the operation much as you would if you wanted to "append" a variable rather than field value.

Field           Expression              Condition
STAT_DTE	Var->edate	 	
field_name      Default Value

And you would enter Default Value literally such as "some text", 123.45, .t..

[[email protected]]

Of course you are correct Stan, and it makes sense to import/append the default value. It does say recalc "calc" fields and not the default values.

In the help file, there is a topic named Re-evaluating field rules. It says you can select Rules> Re-evaluate Rules to re-apply these rules to each record. I can't for the life of me find that. Was this left over from an older version of Alpha and is now renamed recalculate calc fields?

In any case, it does say that it works for calculated fields, case conversion, and all the validation rules but doesn't name default data entry fields. That would be a nice feature though...



Bill Belanger

[Stan Mathews]

It says you can select Rules> Re-evaluate Rules to re-apply these rules to each record. I can't for the life of me find that.
Bill Belanger

Right click on table in control panel. select edit field rules, when edit screen appears select Rules menu, bottom choice is Re-Evaluate Rules.