Subject Re: Funny problem with creation of Primary keys on table
Author Svein Erling Tysvær
--- In firebird-support@yahoogroups.com, Johannes Pretorius wrote:
> we tried this, but it also came back with no results ? We also
> 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.

Huh? Did you remember to commit between deleting and defining the
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