CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> Archive -> GotoCode Archive

 clone a record

Print topic Send  topic

Author Message
Posted: 11/20/2003, 7:47 AM

i would like to be able to clone a record from my grid creating a new record in same table having identical values for all fields with the exception of the ID field which will be the next autonumber value for my table, and a column ParentID which would have the original's ID value. Essentially creating a child record.

I know if i build the insert statement manually using all of the columns and their values that i can do an insert.

Is there an easy way to get at all of the columns and their values? perhaps using DataSource.SQL so that i can create the insert programatically?

Following the insert i'd want to end up back at my grid page.
Posted: 11/20/2003, 8:59 AM

Please refer to this tutorial by sixto :
(free registration required)

Hope this helps

RexDesign CodeCharge Studio Tutorials
Posted: 11/20/2003, 11:53 AM


by the way love the site looks like lots of stuff i want there.


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.