John, If the values you are totalling are in the form, then you are firing your eep too soon. If the values are calc'd before you enter the form, then it should work. Put a pause 2 using .vGTOT into your eep at the beginning and see if you get a total showing up. Good luck, Bernie Lis ----- Original Message ----- From: "John Engwer" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 18, 2004 3:45 PM Subject: [RBG7-L] - Re: setting variable in form
> I am firing "on after start" in the form property. > > John > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis > Sent: Wednesday, August 18, 2004 2:11 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: setting variable in form > > 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. > > > > > > >
