Javier, I think the RECALC command is the one you are looking for. After the insert, use RECALC TABLES. Dan
At 02:02 AM 2/19/2003 -0600, you wrote: > >I am sure there is an easy answer to this question, but somehow it eludes me >right now. I have a form which I want to use to add rows to a table; >however, I want the �ADD ROW� push button to run an EEP that inserts a row >into the table using pre-defined values as I want to use the form in the >edit mode only and I do not want the user to change some of the columns. The >EEP uses the following command: >====================================================================== > INSERT INTO fwo_proc_file (fwo_no,proc_code, + > proc_cost_other,proc_cost_labor,proc_cost_parts,proc_comments ) + > VALUES(.fwono,.vproc,0.0,0.0,0.0,'None') >====================================================================== >However, when I return to the form the record does not show unless I exit >the table and go back in (using PREVTAB NEXTAB). I could possibly use NEWROW >in the EEP and have a playback file that populates the fields on the empty >row; however I am hopeful that there is an easier way. >TIA. > >Javier, > >Javier Valencia, PE >President >Valencia Technology Group, L.L.C. >14315 S. Twilight Ln., Suite #14 >Olathe, KS 66062-4571 >(913)829-0888 >(913)649-2904 FAX >
