Hello,

      I am developing software for the auto dealer/finance industry

and have several symbolic prompts within one of the windows. In

this particular window is a column labeled "Calc APR". This column

calculates the contracts APR. At one time it was a symbolic column.

     I have since had to convert it back to a data column that is

protected. Also I'm calling a program to do the mathematical calculation from a pre-prompt process. The reason for this was when

the window was brought up it calculated columns that did not yet

have any data in them. In this particular situation, the amount financed, no of payments and the payment amount must be known.

    And of course it would throw me into the debugger and give

me an error. My question is: if the user has changed the value of a

prompt, ie the term or no of payments that comes before the Calc APR

column, the value in Calc APR stays the same and how could I make

the cursor go through all prompts when pressing the F9 key so the

Calc APR gets updated?

   Whoooo! Man that's a big question. I just hope I'm asking  the right

thing.

TIA

John K.

You could create a perpetual process that calculates the values each time. You could check what prompt number you are on so it only recalcs when necessary.

Barry

You can do this one of two ways. If you want to recalculate the APR at the time the F9 save is done, then you can call your APR routine from the Winows Pre-Save process.

The other way would be to add to your Post-Prompt routines for Amount Financed, No. of Payments and Payment Amount a check to see if the value in the respective prompt has been changed, if so then call your APR routine and redisplay the data on the screen. This has the advantage of letting the person typing in the data (assuming a salesperson) know right away what the APR will be as soon as they change one of the three values.

I hope this helps.

Michael Slack

You could create another symbolic and then have it dependant in interest rate, loan amount and term. The new symbolic would call the APR calc routines, update @RECORD and redisplay the window using the redisplay window common variables.

[email protected]

Sprezzatura, Inc.

View this thread on the forum...