Re: [GENERAL] Delete after trigger fixing the key of row numbers

2008-03-28 Thread Tomasz Ostrowski
On 2008-03-28 13:27, Teemu Juntunen wrote: > I am developing an ERP to customer and I have made few tables using a > row number as part of the key. When deleting a line from such a > table, I have made an after delete trigger, which fixes the row > numbers with following command: > UPDATE orderro

Re: [GENERAL] Delete after trigger fixing the key of row numbers

2008-03-28 Thread Richard Huxton
Teemu Juntunen, e-ngine wrote: Greetings from Finland to everyone! On behalf of everyone, hello Finland. I joined the list to hit you with a question ;) That's what it's there for. I am developing an ERP to customer and I have made few tables using a row number as part of the key. Frex.