Subject Re: Copy row to row in stored procedure
Author paul.mercea
--- In firebird-support@yahoogroups.com, Valeri Mytinski <valeri.mytinski@...> wrote:
>
> Thanks.
> But it is not EASY way:
> 1) There may be many columns in a table.
> 2) Columns may be added or deleted in the future.
> So maintenance cost of such solution is high,
> and code readability is low.

Maybe you should manage in your application code somethink like:

dataset (or datatable dt) ..populate...and then

DataRow dr = dt.CurrentRow;
dr.Rows["YOURPK"]=Guid.New();
dt.Rows.Add(dr);

Regards,
Paul