Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
Tony Hoyle <tony.hoyle at march-hare.com> writes: > Luigi D. Sandon wrote: >>> little harder that's all since it needs to modify the insert statement. >> No need to modify the insert statement if the sequence is used in a before >> insert trigger. You get the same behaviour of an autoinc column. >> > The issue then becomes retrieving that value - unless the trigger can force > the insert to return it somehow. I posted a selection of alternatives that work with Oracle yesterday. Have my posts to the newsgroup not been getting through? Anthony -- Anthony Williams Software Developer Just Software Solutions Ltd http://www.justsoftwaresolutions.co.uk