Re: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 18/11/16 11:03, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > But I want to use identity fields because such fields don't uses a generator > and a trigger. Putting this a different way ... the correct way of ensuring where multiple users are adding records wh

Re: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Nov 18, 2016, at 7:03 AM, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > > That's right. But I want to use identity fields because such fields don't > uses a generator and a trigger. How can I easily change my old autoincrement > fields to identity What

Re: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2016 12:03, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > How can I easily change my old autoincrement fields to identity fields ? No way. -- WBR, SD. +

RE: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
Fax +32 55 31 00 95 nico.spele...@carfac.com www.carfac.be   -Oorspronkelijk bericht- Van: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Verzonden: vrijdag 18 november 2016 10:38 Aan: firebird-support@yahoogroups.com Onderwerp: Re: [firebird-support] proble

Re: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
That's right. But I want to use identity fields because such fields don't uses a generator and a trigger. How can I easily change my old autoincrement fields to identity fields ? Nico Speleers Analyst Carfac bvba Driving on experience Rijksweg 53 9680 Maarkedal Tel. +32 55 23 00 00 Fax +

Re: [firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2016 8:56, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > I want to change my autoincrement fields made in firebird 2.5.4 (with > generator and > trigger) to an identity field in firebird 3.0.1 without the generator and > trigger. Can > someone give me an

[firebird-support] problem - change autoincrement fields to identity fields

2016-11-18 Thread Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
Hello, I want to change my autoincrement fields made in firebird 2.5.4 (with generator and trigger) to an identity field in firebird 3.0.1 without the generator and trigger. Can someone give me an useful script or another solution? We work in an superserver model and our data access interface i