Javier, In my case I pre-populate tables with keys and default values prior to editing. Subsequent editing is preceded by a check to assure there are enough open lines, and at some pre-determined point excess lines are removed.
While in a region of a child table, when the user makes a choice (choose presented by an eep) the eep updates the table(s) runs a prevtab, recalc tables, nexttab sequence. The only gotcha in this so far is to be sure that the cursor does not return to a field with an entry eep attached. I would imagine something similar would work w/ inserts... but I haven't tried (unsuccessfully) since 6.1. Ben Petersen On 19 Feb 2003, at 2:02, Javier Valencia 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 >
