Re: Duplicating records in sub-datablocks

Jan Schaefer wrote:

> Hi,
>
> I'm using Forms 6 and want to duplicate a record and all records that
> are stored in sub-datablocks and are connected to the record in the main
> datablock.
>
> It's easy to duplicate the record in the main datablock:
>
> go_block('xyz_block');
> create_record;
> duplicate_record;
> change_some_fields_to_avoid_exception;
>
> But how do I duplicate all the records in the sub-datablock(s) that
> belong to the record in the main datablock?
>
> Thanks for your help in advance,
>
> Jan

Assuming your records have primary keys that can not be duplicated ... I would write a stored procedure.

Pass the primary key from the parent block to the stored procedure and let it do the rest.

Then refresh the form with EXECUTE_QUERY;

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)