Hi Artur,

try something like this (I think you can't duplicate Blob data with this):

var
sRowData: String;
begin
sRowData := Qry.Fields.RowData;
Qry.Insert;
Qry.Fields.RowData := sRowData;
Qry.FieldByName( 'PrimaryKey' ).AsInteger := Qry.GeneratorValue(
'Gen_PrimaryKey', 1 );
end;

HTH,
Markus

At 11:07 02.10.2001 +0100, you wrote:

>Hy list,
>
>Is there a simple way in IBO to duplicate a row?
>
>What I want to do it's let the user select a row, and create a new row
>that get's all values from this one, and let the user change that values.
>It's like to have a Edit act as a Append/Insert. For now, I'm creating a
>temporary buffer with the values from the row, do an Append and copy the
>values back.
>
>I wonder if there is a better way, a some kind of flag that we can change
>that tells IBO that this will be a new record.
>
>Thanks in advance,
>
>Artur Anjos
>http://www.arsoft.pt