Lin, Create form variables to capture the values of the 2 columns I'll call them variable1 and variable2
A button on your form would contain this code. SAVEROW INSERT INTO othertable (column1, column2) Values (.variable1, .variable2) NEWROW RETURN Hope this helps Dennis McGrath > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Lin > MacDonald > Sent: Tuesday, February 24, 2015 1:41 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: pre-defined EEPs? > > Great information, but not quite what I was looking for (although I will > keep it as a reference!). > > I want to find out what is happening behind the EEP so that I could > write my own. Maybe I am missing the point. > > -I have a button on my Form that uses the Pre-defined EEP to Save. > -I would like to add something so that when the Ussr hits that button, > it saves the form, then also adds a row in a different table using 2 of > the fields that were input in this form. > -Then, I would like the User to go on and begin to add another row in > the first Table > > Lin > > > > On Tue, Feb 24, 2015, at 09:35 AM, Dennis McGrath wrote: > > Expanding on Razzak's list with command to do the same: > > > Add Row > > > Inserts a new row into the table > > NEWROW > > > > > Add Row and Exit > > > Inserts a new row into the table and immediately exits form > > NEWROW > > SAVEROW > > CLOSEWINDOW > > RETURN > > > > > Delete Row > > > Deletes the current row from the table. Used after row has been saved > or > > > when form is in edit mode > > DELROW > > > > > Discard Row > > > Discards the unsaved row from the table when form is in enter mode > > DELROW > > > > > > > > Discard Row and Exit > > > Discards the unsaved row from the table when form is in enter mode and > > > immediately exits the form > > DELROW > > CLOSEWINDOW > > RETURN > > > > > Duplicate Row > > > Duplicates the current row in the table > > DUPROW > > > > > Exit > > > Immediately closes form and returns to program > > CLOSEWINDOW > > RETURN > > > > > Next Row > > > Advances to the next row in the record set > > NEXTROW > > > > > Next Table > > > Advances to the next table > > NEXTTAB > > > > > Previous Row > > > Advances to the previous row in the record set > > PREVROW > > > > > Previous Table > > > Advances to the previous table > > PREVTAB > > > > > Save Row > > > Saves all changes made to data and resets flag > > SAVEROW > > > > > Last Row > > > Advances to the last row in the record set > > ????? > > > > > First Row > > > Advances to the first row in the record set > > ????? > > > > > Save Row and Exit > > > Saves all changes made to data and resets flag before immediately > > > exiting the form > > SAVEROW > > CLOSEWINDOW > > RETURN > > > > > > > -----Original Message----- > > > From: [email protected] [mailto:[email protected]] On Behalf Of A. > > > Razzak Memon > > > Sent: Tuesday, February 24, 2015 11:10 AM > > > To: RBASE-L Mailing List > > > Subject: [RBASE-L] - Re: pre-defined EEPs? > > > > > > At 11:56 AM 2/24/2015, Lin MacDonald wrote: > > > > > > >This is a pretty simple question but I am a 'weekend programmer' that > > > hasn't > > > >done any for a couple of years! > > > > > > > >Is there any listing anywhere of what the Pre-defined EEPs do? I would > like > > > >to create a custom one that consists of exactly what a Pre-Defined one > > > does > > > >plus adding one line of my own code. i.e add a line of code to a button > that > > > >I have set up to use 'Add a new Row" > > > > > > Lin, > > > > > > Here you go ... > > > > > > > > > Add Row > > > Inserts a new row into the table > > > > > > Add Row and Exit > > > Inserts a new row into the table and immediately exits form > > > > > > Delete Row > > > Deletes the current row from the table. Used after row has been saved > or > > > when form is in edit mode > > > > > > Discard Row > > > Discards the unsaved row from the table when form is in enter mode > > > > > > Discard Row and Exit > > > Discards the unsaved row from the table when form is in enter mode and > > > immediately exits the form > > > > > > Duplicate Row > > > Duplicates the current row in the table > > > > > > Exit > > > Immediately closes form and returns to program > > > > > > Next Row > > > Advances to the next row in the record set > > > > > > Next Table > > > Advances to the next table > > > > > > Previous Row > > > Advances to the previous row in the record set > > > > > > Previous Table > > > Advances to the previous table > > > > > > Save Row > > > Saves all changes made to data and resets flag > > > > > > Last Row > > > Advances to the last row in the record set > > > > > > First Row > > > Advances to the first row in the record set > > > > > > Save Row and Exit > > > Saves all changes made to data and resets flag before immediately > > > exiting the form > > > > > > Refresh Current Table > > > Refreshes the records in the current table to reflect any changes made > > > since the last refresh > > > > > > Hope that helps! > > > > > > Feel free to reach out to me with any questions. > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > > www.rbase.com > > > www.facebook.com/rbase > > > -- > > > 32 years of continuous innovation! > > > 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! > > > -- > > > > > > --- RBASE-L > > > ================================================ > > > TO POST A MESSAGE TO ALL MEMBERS: > > > Send a plain text email to [email protected] > > > > > > (Don't use any of these words as your Subject: > > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > > ================================================ > > > TO SEE MESSAGE POSTING GUIDELINES: > > > Send a plain text email to [email protected] > > > In the message SUBJECT, put just one word: INTRO > > > ================================================ > > > TO UNSUBSCRIBE: > > > Send a plain text email to [email protected] > > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > > ================================================ > > > TO SEARCH ARCHIVES: > > > Send a plain text email to [email protected] > > > In the message SUBJECT, put just one word: SEARCH-n > > > (where n is the number of days). In the message body, > > > place any > > > text to search for. > > > ================================================ > > > > > > > >
