Hi all,

I've been staring at this block of code now for 4+ hours, and I don't get it.

I have created a payment subtable, with the values of PdHere or PdDir to determine payments made to our office, or to our clients' office.

All I want to do is come up with a total of the payments made here and there to work out a balance.

I've liberally used WriteLn to check my results.  I've confirmed my count of the number of payment items (vCount) is correct.  However, it's repeating the first value on the subtable.  

For example, if I have three payments of $10, $50, and $5, the sum it calculates is $30 (counting three payments, but repeatedly adding the first value of $10, $10, and $10).

Can anyone see what I'm missing here?

Thanks.
Blair

// Give Total Collected

vRecord = 1
vCount = @FormResultSetTotal("Pmt Data")
vPdHere = 0
vPdDir = 0

if vCount >0 then
{
      While vRecord <= vCount
      {
            vPdHere = @TM(vPdHere) + @TM(@FormFieldValue("Pmt Data", "PdHere", vRecord))
            vPdDir = @TM(vPdDir) + @TM(@FormFieldValue("Pmt Data", "PdDir", vRecord))
            vRecord = vRecord + 1
      }
      DBPd = vPdHere + vPDDir
}
 

This code executes on the main form, on form entry.

On form entry, the variables are declared - vRecord, vCount are int, and vPdHere and vPdDir are double.  The subtable records I pull data from (PdHere and PdDir) are money fields.  DBPd is a money field as well.

Does any of this help?

Blair,

Are you using the latest release (1.1.2)? I experienced, what seems to be exactly the same thing, way back with version 1.0.2.

See this thread:
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=archived;action=display...

This issue was resolved with the release of 1.0.3, and I just did some testing with 1.1.2, which is still working correctly.

Blair,

Send me the app that this code is in. Be sure to include Login and password as well as the form name that this code is on.

-Ray

Hello Blair,

In your subforms on Form Entry command you have a call to NotifyForm(1). This is prohibiting your Main Form from advancing to the next subrecord. The reason for this is because NotifyForm(1) is not just prohibit Save, it is Prohibit Save, Advance and Retreat of the current record. If you remove that line of code your other code will work fine.

-Ray

Blair,

I just added @FormNotifyForm, FormNotifyForm, and FormIsNotifyForm that all accept a form name (as well as the notify flag), That way you can turn things on and off for subforms from the parent. It'll be in 1.1.3.