Answer Posted / shaikyesvee
SumIndex fields are associated with the keys of the table. You can relate multiple SumIndex fields with a particular key. Each key can have at most 20 SumIndexFields.
SumIndexFields enable fast calculation of numeric columns in tables, even in tables with thousands of records. This is because SumIndexFields are maintained when the database record is updated.
SumIndex is a Indexing feature, to enable fast calculations, and the fields are not ment to be accessed, unlike the FlowFields.
FlowFields are virtual fields in the Table. It is not a permanent part of the table data. It is used to calculate values from another or same table based on CalcFormula specified for the field. The information in the FlowFields exists only at run time.
To update a FlowField you can you CALCFIELDS function as: record.CALCFIELDS("FieldName")
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
send a background email when any user unblock an item card?
google maps - show in map / show route in customer or vendor card?
what is delayed insert property?
Difference between item reclass and item movement?
how to disable zoom (ctrl+f8) from a form?
When You're Talking About Item Movement, Are You Talking About Transfer Order Or Warehouse Movement?
When you're talking about item movement, are you talking about trfer order or warehouse movement?
What are the web services?
Difference between Item reclass vs item movement?
What Is Transheader & Transfooter?
how to restrict workdate for several users
what is totalscausedby function (report)?
how to check the user name who locked the table?
difference between transfer orders and item reclass journal?
How to Make a field editable on a non-editable form?