Is there a simple way to insert a new, duplicate row into a table? It would be useful to be able to copy an entire row and paste it back into the table.
Regards
David
pzajac
Joined: 03 Aug 2007
Posts: 17
IJC personnel
The problem with gridview is that I have a relational database with chemical compounds in one table and associated packages in a separate table. I would like to create a duplicate package record from the form view because the package table does not include the actual chemical information - only the specific package information.
Does that make sense?
Cheers
David
tdudgeon
Joined: 05 Oct 2004
Posts: 617
IJC personnel
The ability to duplicate a row has previously been suggested and we plan to implement this.
For now though I think Petr's suggestiuon of using copy and paste should work, assuming I have understood your needs correctly.
If you have a structure table and a detail table that contains your package data and this package table has a many-to-one relationship to the structure table (which presumably it must if you are trying to add a second row) then you can create a form that contains the structues and a table widget that contains the package info. In that table widget you should be able to use copy and paste to create a new row with the same values as the copied row.
But of course a "add new row like this one" function would be simpler.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum