At 02:50 PM 4/15/2011, Dick Fey wrote:
On occasion we need to duplicate a row in our product database,
where perhaps only 1 or 2 fields change out of 50.
Is there any way to add and duplicate a row so you can just
edit those 1 or 2 fields ?
Been using R:base for 24 years and don't know the answer to
that question !
Inquiring minds want to know.
Dick,
Hope you are having fun with R:BASE eXtreme 9.1 (32).
Did you know that you can use the DUPLICATE option of the
PROPERTY command to duplicate the selected row in a form
(one row at a time), Scrolling Region, or DB Grid?
Here's how:
Place a Speed Button or Enhanced Speed Button with following
code as Custom EEP:
-- Duplicate Row
PROPERTY TABLE <FormTableName> 'DUPLICATE'
RETURN
The 'DUPLICATE' option will DUPLICATE the selected
row for a given table related to that form.
Substitute the <FormtableMame> with the actual table
name.
-- Example:
-- Duplicate Row
PROPERTY TABLE Customer 'DUPLICATE'
RETURN
This will duplicate the currently selected row in Customer
table and then switch the focus to duplicated row (makes
the duplicated row as the current row).
That's all there is to it!
Very Best R:egards,
Razzak.
