>> 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 > >
