Updating Edit Tables in OI (None Specified)
At 25 NOV 1998 01:29:06AM Phil Thalmann wrote:
In my attempts to convert an Arev app to OI I've run into another wonderful stumbling block (to which I'm sure someone has the simplest answer
.
In the Arev app there were several associated MVs. A symbolic was called from the post-prompt of one of these fields to recalculate a number of the AMVs.
I tried to emulate this by creating a script called at LostFocus. However given that I've setup the AMVs in OI in an Edit Table, the LostFocus does not happen on the move from one AMV column to another but when you leave the AMVs altogether. Hmmm..
How would one go about doing this recalc midstream ?
This is the original code used in the symbolic (love the case):
$INSERT INCLUDE,AREV.COMMON
DECLARE SUBROUTINE MSG
IF NOT( WCHANGE ) THEN GOTO DONE
@RECORD=IS
BUDGET ='
CUR_YR ='
COMMIT ='
DEVIATE='
CNT=COUNT(@RECORD,@VM) + 1
FOR I=1 TO CNT
BUDGET += @RECORDCUR_YR += @RECORDCOMMIT =@RECORDDEVIATE=BUDGET - ( COMMIT + CUR_YR )NEXT I
@RECORD=DEVIATE
REDISPLAY.LIST=13
DISPLAY.ACTION=6
DONE:
Any and all suggestions greatly appreciated,
Phil
At 25 NOV 1998 03:32AM [email protected] [url=http://www.sprezzatura.com]Sprezzatura Ltd[/url] wrote:
[notag]Have you looked at POSCHANGED?
[<A HREF="mailto:[email protected]" onMouseOver="window.status='Why not click here to send me Email?';return(true)">Andrew McAuley</A>]
[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Why not click here to visit our web site?';return(true)">Sprezzatura Ltd</A>]
[<I>World Leaders in all things RevSoft</I>]
[<img src="http://www.sprezzatura.com/zz.gif">]
[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:[email protected]">Send mail to support at Sprezzatura <OPTION VALUE="mailto:[email protected]">Send mail to sales at Sprezzatura </SELECT> </FORM>][/notag] </QUOTE> —- === At 25 NOV 1998 03:35AM Oystein Reigem wrote: === <QUOTE>Phil, Fast answer (I've only read the beginging of your message and not as far as your code): There is a different event called POSCHANGED that occurs when you change from one edit table cell to another. - Oystein - </QUOTE> View this thread on the Works forum...