This can be done by going to Tables Add/Remove Tables Table Settings On Row Entry Eep
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Posted At: Thursday, August 19, 2004 2:39 PM Posted To: RB7-L Conversation: [RBG7-L] - Re: Variables recalc in forms Subject: [RBG7-L] - Re: Variables recalc in forms Javier and David, thanks for your help. I have the property syntax correct, I just typed it wrong in the Email (PROPERTY FORM puredit1 'REFRESH'). Here is some more information; maybe you can help me find what is wrong. If I do an edit using puredit1 where the last name = Jones I get a lot of records as expected. As I step through the names to find John Jones the var vAMT_OWED does not update as I move from record to record. Maybe it shouldn't because the EEP triggers on entry to the name field. Once I find John Jones, if I click on the address field and then click again on the name field the var updates. If I use a where clause and go directly to John Jones the var displays properly. Is there a way to fire the EEP every time I move to a new record in my puredit1 form? John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Javier Valencia Sent: Thursday, August 19, 2004 3:08 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Variables recalc in forms >> Try: >> >> Property TABLE puredit1 'REFRESH' It should be: PROPERTY FORM puredit1 'REFRESH' If you want to refresh the form, or: PROPERTY TABLE your_table_name 'REFRESH' If you want to refresh the table. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David M. Blocker Sent: Thursday, August 19, 2004 1:58 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Variables recalc in forms John Your PROPERTY command is refreshing the TABLE but it has in in the name of the FORM!!! Try: Property TABLE puredit1 'REFRESH' Also, the COMPUTE command should be used ONLY when SELECT won't do the job, as in COMPUTE varname AS ROWS FROM table COMPUTE varname AS STD (columnname) FROM table COMPUTE varname AS VARIANCE (columnname) FROM table Instead use: SELECT SUM (amt_owed) INTO vamt_owed INDICATOR vI1 from invoice WHERE cust# = .vcu_no David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "John Engwer" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 19, 2004 2:14 PM Subject: [RBG7-L] - Variables recalc in forms > I am still having great difficulty getting my variables to update > properly in forms. Here is what I am doing: > > I have a form with a main table is called customer that is used to > edit customer information and display the customers purchase history > in a DBGrid > from the purchase table. > The form name is puredit1 > Form is set as one - many > I have a variable called vAMT_OWED that I want to display the amount > that the customer owes. > I am using the following EEP to perform the calculation > > SET VAR vamt_owed = 0 > COMPUTE vamt_owed AS SUM amt_owed from invoice WHERE cust# = .vcu_no > Property TABLE puredit1 'REFRESH' > recalc variables > RETURN > > I have traced the EEP and it calculates the correct amount and puts it into > the var vAMT_OWED > > I currently have the EEP triggering on entry to the customer name > field in the customer table. I have tried it "on entry to" of various > fields on the > form. > Sometime when I click on the .vAMT_OWED field, the field will update > properly. > > Does anyone have an idea as to what I may be doing wrong? > > John > >
