Re: [firebird-support] Altering a domain

2015-06-20 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Thank you Ann. Greetings. Walter. On Sat, Jun 20, 2015 at 9:04 AM, Ann Harrison aharri...@ibphoenix.com [firebird-support] firebird-support@yahoogroups.com wrote: On Jun 19, 2015, at 3:32 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]

Re: [firebird-support] Altering a domain

2015-06-19 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Excellent explanation Ann, as always. Just one doubt: After a cycle backup/restore: the restored database will have all the rows with the new domain? All columns with domain D_CURRENCY that were created with DECIMAL(9, 2) now will be DECIMAL(18, 2) ? Greetings. Walter. On Tue, Jun 16, 2015

[firebird-support] Altering a domain

2015-06-16 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hi, I have defined the following domain : CREATE DOMAIN CURRENCY AS decimal(9,2) I would like to alter it as the following : ALTER DOMAIN CURRENCY AS decimal(18,2) I have many fields in tables that depend on this domain and they are filled with values. Will they be

Re: [firebird-support] Altering a domain

2015-06-16 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: I have defined the following domain : CREATE DOMAIN CURRENCY AS decimal(9,2) I would like to alter it as the following : ALTER DOMAIN CURRENCY AS

Re: [firebird-support] Altering a domain

2015-06-16 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Ann, thank you very much for your clear explanation. Aldo El 16/06/15 a las 12:44, Ann Harrison aharri...@ibphoenix.com [firebird-support] escibiĆ³: On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com mailto:aldo.car...@argencasas.com [firebird-support]