John, Please clarify, Are you firing it after-entry in the field you want the total to appear? Perhaps you could fire it after-entry in the field prior to the total field. Bernie Lis ----- Original Message ----- From: "John Engwer" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 18, 2004 11:59 AM Subject: [RBG7-L] - Re: setting variable in form
> Bernie, I am summing the col tprice (and others) in the purchase table for a > specific invoice number. I am using the form to summarize the purchase and > add in other special charges as appropriate. The eep to set vGTOT works > fine if I fire it "after entry" instead of "on entry" to the var edit field. > > John > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis > Sent: Wednesday, August 18, 2004 11:33 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: setting variable in form > > John, > Are you calculatin something like Price * Qty ? > if so put you eep in the last object (price or qty) in the on-exit from that > column section. > Bernie Lis > ----- Original Message ----- > From: "John Engwer" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, August 18, 2004 11:17 AM > Subject: [RBG7-L] - Re: setting variable in form > > > > I moved the eeps that calculate vGTOT to after form entry and everything > > works properly now. > > Question... Should I be able to calculate the the var vGTOT on enter to > the > > field (with recalc) and have it display properly? I have read only checked > > in the field property. > > > > John > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Engwer > > Sent: Wednesday, August 18, 2004 10:24 AM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: setting variable in form > > > > I did try the recalc variable but I get the same result. I even tried > > changing the select to a compute but it made no difference. I traced the > > eep and I can see the var vGTOT is set to the correct value but the > contents > > of the var field remains 0.00. I also deleted the var field and > re-inserted > > it. > > This is a form that is called by another form if that makes any > difference. > > John > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak > Memon > > Sent: Wednesday, August 18, 2004 7:40 AM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: setting variable in form > > > > > > At 02:29 AM 8/18/2004 -0400, John Engwer wrote: > > > > >I have an eep used in a form to calculate purchase amounts from a > purchase > > >table. For some reason the eep does not run on entry to a var edit field > > >(vGTOT). It runs fine outside of the form. Any idea what may be wrong? > I > > >tried adding a recalc variable to the eep but it did not help. > > > > > >--Sum of current purchases > > >SELECT SUM(vtprice) + > > >INTO vGTOT INDICATOR vind_SUM + > > >FROM purchase + > > >whe inv# = .vnew_inv_no > > >return > > > > John, > > > > Add the RECALC VARIABLES before the RETURN statement in your EEP > > and see what happens. Your EEP should look like the following: > > > > -- Sum of current purchases > > SELECT (SUM(vtprice)) + > > INTO vGTOT INDICATOR vind_SUM + > > FROM purchase + > > WHERE inv# = .vnew_inv_no > > RECALC VARIABLES > > RETURN > > > > In order to test "On Entry EEP" for Variable Edit, try the > > following test and see what happens: > > > > PAUSE 2 USING 'This is On Entry EEP' ICON INFO > > RETURN > > > > For more examples, take a look at the "Sales Order" routines > > and EEPs used in Running R:BASE Your Way! (Part 9). > > > > Finally, you may want to TRACE the entire process to see > > where things are not working. > > > > Hope that helps! > > > > Very Best R:egards, > > > > Razzak. > > >
