Using a trigger I encounter a problem which I don't understand.
I have to fill a text column which has to be computed as follows: Year as text + Daynumber as text + Primary Key as text I have written a stored procedure which needs to be executed after the insert. I am catching the last used PK using the where clause as count=insert It works almost ok, but if I insert a new row the column is still empty and if I insert another row the concerned column of the new rows is empty, but then the column is filled in row which I have created before the last one. Why does it works this way and what do I have to do to have the column filled when the particular row is created and not one row later? Tony
