Re: Autopopulation by concatenation

Coburn Watson wrote:
>
> I have a relatively basic table which, when insertions are made, I would
> like the last field (trackid) to be generated by concatenating the
> values of the first two fields (num1 & place1). For example, if I
> insert a row into this table with the data (num1, place1)values (4,
> paris), then I would like my trackid field to be "4paris". I attempted
> to perform this action with an AFTER INSERT trigger, but I get the
> "mutating" table error. I take this is since the data which the trigger
> is relying on has just been inserted and is unavaible for selection
> (?!?). Any help would be appreciated.
>
> Coburn Watson
> Information Systems Support - Research
> Scios, Inc.
> cpw_at_slip.net

Forgot to add one thing: The reason I'm not populating the field at time of insert is that the table is being inserted into from another group's application(chemical package), and they aren't modifying the interface. This is supposed to be a behind-the-scenes action so as to generate a value which can be used as a unique identifier between our instances.

Thanks,
Coburn Watson
Info. Systems Support - Research
Scios, Inc.
cpw_at_slip.net Received on Tue Feb 11 1997 - 00:00:00 CST