Refreshing calculated columns in an edittable (OpenInsight Specific)
At 13 APR 1998 10:24:22AM Jeff Word wrote:
I have an edittable with two columns. First column is a code and the second is a description of that code. A separate table is the master table where code and description are stored.
When you enter the code, the description should display instantly. The description column formula looks like this:
@Ans=Xlate( 'MEDICATION', {MEDICATION_CODE}, 'DESCRIPTION', 'X' )
{MEDICATION_CODE} is multivalued. When the record reads, the description displays properly. However, if I add one, it goes to the next control and leaves the description blank. It it my understanding that using the {MEDICATION_CODE} in the xlate creates a dependency so OI knows that when a code is entered or changed that the dependent controls calculate. This approach works for edit lines but I cannot get it to work with edittables. Advice please.
At 13 APR 1998 10:34AM Dave Pociu wrote:
Jeff,
The recalculations depend on how the DEFPROP property of the table is modified. Here's how you can force the re-display of the symbolic:
Send_Event( EditTable , 'CALCULATE' , column_number )
This approach works for me whenever I update the edit table data programatically and need a symbolic in one of it's columns to re-calculate.
On the other hand, the symbolic re-calculation seems to work fine for me when I type data in rather then fill it in programatically. If that's your problem than you might need to dig deeper and see what's going on.
Dave