{{tag>category:"OpenInsight 32-Bit" author:"John Bouley" author:"Donald Bakke"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Calculate Event on Edit Tables (OpenInsight 32-Bit) ====
=== At 31 JAN 2005 03:52:03PM John Bouley wrote: ===
 
 
<QUOTE>
I am having a problem with the Calcualte event after modifying the contents of an Edit Table. If I understand things correctly the Calculate only works from the window's Record property. So I wrote a sub to Refresh the Record property from the actual controls. I have verified that the controls have the correct data and the Record property has the right data but my formula will not calculate.



The formula is part of the same Edit Table...



Thanks,

John
</QUOTE>
----

=== At 31 JAN 2005 04:05PM Donald Bakke wrote:  ===

<QUOTE>John,



Are you using INVALUE or DEFPROP to update the EditTable? If you are using the ARRAY property this might be your problem.



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 31 JAN 2005 04:09PM John Bouley wrote:  ===

<QUOTE>INVALUE

</QUOTE>

----

=== At 31 JAN 2005 04:16PM Donald Bakke wrote:  ===

<QUOTE>John,



I hate to ask this, but you *are* passing in the correct column number in the Send_Event call right?



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 31 JAN 2005 04:41PM John Bouley wrote:  ===

<QUOTE>Don,

Thanks for asking. I was issuing a call send_event(ctrl,"CALCULATE") where ctrl is the Edit Table. What is the syntax for the specific control?



John

</QUOTE>

----

=== At 31 JAN 2005 04:50PM John Bouley wrote:  ===

<QUOTE>Thanks Don,



Just figured it out. call send_event(ctrl,"CALCULATE",column)



works like a charm!



John

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=0E4562C0E31D103485256F9A0072A14C|View this thread on the Works forum...]]