Subject | Re: Funny problem with creation of Primary keys on table |
---|---|
Author | Svein Erling Tysvær |
Post date | 2006-02-03T14:31Z |
--- In firebird-support@yahoogroups.com, Johannes Pretorius wrote:
primary key? Deleting is DML and defining keys are DDL, and they
should never be mixed.
I cannot think of any other reason for this to fail (I think Claudios
document should be old enough for IB 5.6 - I think he wrote it around
the time IB 6.0 appeared), so if it is any other reason I cannot help
you (though Ann and a lot of others probably can).
Set
> we tried this, but it also came back with no results ? We alsoHuh? Did you remember to commit between deleting and defining the
> created a clean table and pumped all the data to the clean table and
> then tried it on that table and it still came back with nothing.
primary key? Deleting is DML and defining keys are DDL, and they
should never be mixed.
I cannot think of any other reason for this to fail (I think Claudios
document should be old enough for IB 5.6 - I think he wrote it around
the time IB 6.0 appeared), so if it is any other reason I cannot help
you (though Ann and a lot of others probably can).
Set