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

2008-03-28 Thread brian
Teemu Juntunen, e-ngine wrote: Hi Tomasz, with receipt rows I can't see any other option with key as running number. First I tried to use serial, but it didn't start from zero again when the foreign key (receipt number) changes. It just continues the serial despite of the foreign key. Then I

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

2008-03-28 Thread Teemu Juntunen, e-ngine
Hi Tomasz, with receipt rows I can't see any other option with key as running number. First I tried to use serial, but it didn't start from zero again when the foreign key (receipt number) changes. It just continues the serial despite of the foreign key. Then I decided to do my own serial which