how do I duplicate a record

[Jberry]

Hello everyone,

Using App server 8

I have a flat file table and I want to let the user duplicate a record but I don't see how or where this is done. Maybe I need to add a button to the web page with some XBasic code to accomplish this?

Any pointer appreciated.

Thanks

-John

[Paul Velke]

Re: how do I duplicate a record

There may be better ways, but you could lookup the fields from the record you want based on a variable, then enter those values into a new record. Here is an example for one field, the code would go in the AferValidate section of a dialog:

tempnote = lookup("[PathAlias.adb_path]\workorders", "workordernum="+session.workorder,"notes")

t = table.open("[PathAlias.ADB_Path]\workorders")
	t.enter_begin()
	t.notes = tempnote
	t.enter_end(.t.)
t.close()

[EricN]

Re: how do I duplicate a record

Hello John,

Welcome!

This is one of my duplicate methods. On this particular grid, I use the lookup method (see pics). I allow my users to "Duplicate previously posted jobs" then make minor changes to customize it. This fills all the necessary fields except the drop down fields on the grid.

OR fill fields from their previously submitted sites. This also fills several fields in this grid.

I first create calculated fields (see Dup2). Duplicate2 = "Duplicate previously posted jobs!" and Sites2 = " Fill fields from your submitted sites"

Then place these calc fields in the "Selected" column. Then choose "lookup" (see Dup3) and field map the fields.

I use this method on several grids.

Hope this helps!

[Steve Workings]

Re: how do I duplicate a record

John - you might also check the help docs for <tbl>.record_clone() and see if that fits your needs.

[Jberry]

Re: how do I duplicate a record

Hi and thanks for all the replies. I've been out of town so I haven't had time to check these out. I'm going to start doing that today and will let you know.

Thanks again

-John

[Rudy16]

Re: how do I duplicate a record

Here is a method without code.

In design mode for a form,
Bring down the Task List
Click on "Pre-Defined" Buttons Tab
Scroll down to "Records"
Click the "+" to open all entries for "Records"
Select "Duplicate Record" by clicking on it
Save

Now all a user has to do is highlight (select) a record from a browse, etc., and press the "Duplicate Record" button and it's done. He/She then can change any data in the duplicate record and save it.

[NoeticCC]

Re: how do I duplicate a record

Here is a method without code.

In design mode for a form,
Bring down the Task List
Click on "Pre-Defined" Buttons Tab
Scroll down to "Records"
Click the "+" to open all entries for "Records"
Select "Duplicate Record" by clicking on it
Save

Now all a user has to do is highlight (select) a record from a browse, etc., and press the "Duplicate Record" button and it's done. He/She then can change any data in the duplicate record and save it.

Unfortunately this is the WAS section - what you posted refers to DESKTOP forms. However I can imagine some of the code would be similar.... just not the same!

[Hansolo]

Re: how do I duplicate a record

Hello John,

Welcome!

This is one of my duplicate methods. On this particular grid, I use the lookup method (see pics). I allow my users to "Duplicate previously posted jobs" then make minor changes to customize it. This fills all the necessary fields except the drop down fields on the grid.

OR fill fields from their previously submitted sites. This also fills several fields in this grid.

I first create calculated fields (see Dup2). Duplicate2 = "Duplicate previously posted jobs!" and Sites2 = " Fill fields from your submitted sites"

Then place these calc fields in the "Selected" column. Then choose "lookup" (see Dup3) and field map the fields.

I use this method on several grids.

Hope this helps!

EricN... I don't know if your still posting on this board but I wanted to thank you for this solution. It has given helped me specifically solve this problem with duplicating based on previous records. Fantastic!

Chuck

[EricN]

Re: how do I duplicate a record

Hello Chuck,
I'm still here! Thank you for the compliment, however that post was a while ago and I have since improved how I do this.

My employers post jobs similar to ones they have already posted so I have a screen (pic 1) displaying jobs they have in the system. The user clicks the job to be duplicated. Inside the (pic 1) page, I have this code (pic 2). I set the session.vPostnum by whatever the chosen job's postnum is. This session.vPostnum is then used in a dialog to fill the dialog's fields. See the initialize event in (pic 3).

Once the user has made the changes for this job and clicks the dialog's submit button, the aftervalidate contains:

dim tbl as P
tbl=table.open("[pathalias.adb_path]\posts")
tbl.enter_begin(.T.)

........... fields to enter ........

tbl.enter_end(.T.)
tbl.close()

and creates the new job.

[Hansolo]

Re: how do I duplicate a record

In my case the user has to enter patient data. The database contains some 5000 patients currently and some are now repeating assessments. I am using your method to allow the user to look up the patient and once found auto fill the demographics and other things that don't typically change over time. Saves some time according to the user (although I think the search eats that up) more important to me is that it limits mistakes and keeps name spellings consistant. Your new method looks interesting if a bit more code rich. Is there some limitation of the old method that I should be aware of? Seems to work very well so far.

Thanks again.

[EricN]

Re: how do I duplicate a record

No. The first method (post #3) worked fine. I just didn't like how it looked and what I use now seems to meet my needs better.

[ewc]

Re: how do I duplicate a record

concerning duplicating records. Does anyone know how to duplicate the form and the grid at the same time. I have been able to duplicate the record form, but it does not duplicate the items in the grid. I have companies that send in say 50 orders, each one with a different purchase order but the same items. The orders are this way because of shipping to different locations and times. If i can duplicate the whole record i could just change the order number and shipping point.

thanks

Earl