> The problem is I can't use a generator, because the number is not
> sequential. I must use a "trigger before insert" to calculate the
> primary key.

Put the code that does that insert into a stored procedure, then, have the
stored procedure RETURN the new value in an output parameter. Put that
stored procedure in the InsertSQL property. Make sure the return column has
the same name as the column in the SELECT statement of the dataset. IBO
should go ahead and pluck that new value returned from the stored procedure
and put it into your buffer for you.

Don't use the SUSPEND token in this select procedure since this ins't a
stored procedure to return multiple rows.

Let us know how it goes.

Jason Wharton