> > never struck this error but really, IMHO, this statment would
> be too easy to
> > break up into an insert and several updates under the one
> transaction, so it
> > would never hold my development up.
> > Alan
>
> It's not clear to me, what exactly you mean? Can you please clarify it a
> little bit.
>
> Regards
>
> Guido

Start Transaction
Step 1: get the PK value (by querying the (GENID, 1)).
Step 2: INSERT INTO TABLE (PKFIELD, FIELD1, 2, 3, 4, 5 ETC) VALUES
(YOURPKVAL, :PARAM1, 2, 3, 4, 5 ETC)
Step 3: UPDATE TABLE SET FIELD5=:PARAM5, 6=6, 7=7, 8=8, 9=9 ETC WHERE
PKFIELD=YOURPKVAL
Step 4: thru however many steps required to make the complete row
Finally Commit Transaction

Alan