Re: [firebird-support] Digest Number 9396

2016-11-18 Thread Dalton Calford dcalf...@distributel.ca [firebird-support]
Interesting, only one record. The RDB$ domains are auto generated by the system - RDB$1297080260861 says that it is the 1,297,080,260,861 domain created by the system. If this is not the only auto-generating domain you have been using, it is possible that you have hit the maximum

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

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 +32 55

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] Digest Number 9396

2016-11-18 Thread tiberiu_horv...@yahoo.com [firebird-support]
Thank you for your answer, "You have data in your column in that table that no longer fits in the new definition" The data in a table that uses one of those domains has only one record, I do not alter that record at all (some document type name default defined). I create many

Re: [firebird-support] problem - change smallint fields to boolean fields

2016-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2016 8:57, Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] wrote: > I want to change my smallint fields made in firebird 2.5.4 to boolean fields > in firebird > 3.0.1. Can someone give me an useful script or another solution ? Drop all dependencies, create a

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

[firebird-support] problem - change smallint fields to boolean fields

2016-11-18 Thread Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
Hello, I want to change my smallint fields made in firebird 2.5.4 to boolean fields in firebird 3.0.1. Can someone give me an useful script or another solution ? We work in an superserver model and our data access interface is FB Maestro 15.11.0.4. Thanks in advance. Nico Speleers Analyst

[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