Lin
You can create a 2 buttons with a custom eep
Create two variables in the form
vcolumn1 = column1
vcolumn2 = column2
vContinue = 99
SAVE Button and Continue
*******start custom eep************
SAVE ROW
INSERT INTO table2 (column1,column2) VALUES .vcolumn1, .vcolumn2)
SET VAR vContinue = 1
--exit to calling code
CLOSEWINDOW
*********end custom eep*********
SAVE Button and Quit
*******start custom eep************
SAVE ROW
INSERT INTO table2 (column1,column2) VALUES .vcolumn1, .vcolumn2)
SET VAR vContinue = 99
--exit to calling code
CLOSEWINDOW
*********end custom eep*********
Depending on how you are calling the form
If vContinue = 1 then
ENTER USING formName
--EDIT USING formName
ELSE
GOTO EndCodeHere
One thing about R:Base there can be 10 different ways to accomplish your
task. You will just have to decide which suggestion works best for you.
Buddy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Lin
MacDonald
Sent: Tuesday, February 24, 2015 2: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.
> > ================================================
> >
>
>
