Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-24 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
*From:* mailto:firebird-support@yahoogroups.com firebird-support@yahoogroups.com *Sent:* Sunday, August 23, 2015 5:48 AM *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Re: Differences when adding a Primary Key Nobody knows the answer? Well, then I shall add

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-24 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
? regards, Karol Bieniaszewski *From:* mailto:firebird-support@yahoogroups.com firebird-support@yahoogroups.com *Sent:* Sunday, August 23, 2015 5:48 AM *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Re: Differences when adding a Primary Key Nobody knows the answer

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-24 Thread liviusliv...@poczta.onet.pl [firebird-support]
@yahoogroups.com Subject: Re: [firebird-support] Re: Differences when adding a Primary Key Hello Karol No, I don't have a backup previous to add the Primary Key then I can use for reproduce the problem. Using ISQL, one time I try to add the Primary Key without using the word CONSTRAINT, seconds

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-24 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
:* mailto:firebird-support@yahoogroups.com firebird-support@yahoogroups.com *Sent:* Monday, August 24, 2015 5:00 PM *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Re: Differences when adding a Primary Key Hello Karol No, I don't have a backup previous to add the Primary

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-23 Thread liviusliv...@poczta.onet.pl [firebird-support]
@yahoogroups.com Subject: Re: [firebird-support] Re: Differences when adding a Primary Key Nobody knows the answer? Well, then I shall add this to the Firebird's mysteries. Greetings. Walter. On Fri, Aug 21, 2015 at 4:47 PM, Walter R. Ojeda Valiente sistemas2000profesio...@gmail.com

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-22 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Nobody knows the answer? Well, then I shall add this to the Firebird's mysteries. Greetings. Walter. On Fri, Aug 21, 2015 at 4:47 PM, Walter R. Ojeda Valiente sistemas2000profesio...@gmail.com wrote: Hello Ann Well, the world has not falled out, nothing so dangerous, the error message

[firebird-support] Re: Differences when adding a Primary Key

2015-08-21 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Nobody knows? Nobody has any idea? Greetings. Walter. On Thu, Aug 20, 2015 at 10:45 AM, Walter R. Ojeda Valiente sistemas2000profesio...@gmail.com wrote: Hello everybody For add a Primary Key to a table we can write: ALTER TABLE MyTable ADD PRIMARY KEY (ID); or we can write: ALTER

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-21 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hello Ann Well, the world has not falled out, nothing so dangerous, the error message is: Cannot commit transaction: The insert failed because a column definition includes validation constraints. validation error for column ID, value *** null ***. The question is: Why without using CONSTRAINT

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-21 Thread Ricardo Uzcategui ricardou...@cantv.net [firebird-support]
hi. Maybe you post an ilegal name or this name are not unique for entery database objects name's. every object in firebird database must be unique. no matters if the same name is used on diferent tables. On Fri, Aug 21, 2015 at 12:24 PM, 'Walter R. Ojeda Valiente'

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-21 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Hello Ricardo Thank you for your answer, but that is not the problem. Without using CONSTRAINT doesn't work and in such case the name is choosed by Firebird, not for me. Greetings. Walter. On Fri, Aug 21, 2015 at 1:43 PM, Ricardo Uzcategui ricardou...@cantv.net [firebird-support]

Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-21 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 21, 2015, at 2:13 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: Without using CONSTRAINT doesn't work and in such case the name is choosed by Firebird, not for me. For add a Primary Key to a table