Don't use RowData to do this if you have BLOB or ARRAY columns.

I suggest you use the Fields.Values[ '*' ] variant array instead.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Riho-Rene Ellermaa" <r.ellermaa@...>
To: "IBObject (E-mail)" <IBObjects@yahoogroups.com>
Sent: Monday, March 04, 2002 5:00 AM
Subject: [IBO] Duplicating rows


> Hi!
>
> I'm trying to use RowData for creating duplicate record (client selects
old invoice and creates new one from that).
> Duplication works OK, but I encountered couple of problems:
>
> 1. I'm using AfterInsert to fill in some fields (doc.no., statuses etc)
and I also have generator for ID-s.
> This function is called before I set RowData values, so I have to set ID
and DOCNO manualy afterward. This means, that
> my generator and document numbering systems loose one value. Can I disable
generator and AfterInsert during duplication?
>
> 2. After duplication (query i still in Insert state) the new data whows ok
on the grid, but TIB_Edit fields (etc.) are empty. They start showing values
only when I click on them. Should I call some kind of method to get the
values visible in Edit fields also?
>
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank