Ben: This is what I am doing right now, PREVTAB NEXTTAB, it is not too much of a problem on the faster computers but on the slower ones there is a screen bleep, going back and forth between tables; I was hoping that there was a command that I had overlooked. I have asked several times (without luck) for a REFRESH SCREEN command. Thanks for the info. 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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Petersen Sent: Wednesday, February 19, 2003 3:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Form Question 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 >
