Trust ID PBCEX logo 300x102

Primary Key forced to use or Compound Key?

5 years 4 weeks ago
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Topic Author
Primary Key forced to use or Compound Key? #4983
Hi Guys,

is it possible to disable the use of a primary key or to use a compound key with a database or in this special case with a oracle database?

Best regards Ingo

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
5 years 4 weeks ago
Sergio Agostinho
Administrator
Administrator
Posts: 508
More
Primary Key forced to use or Compound Key? #4986
Hi Ingo,

In step 4 of the database wizard you can change the way that CardExchange handles the table keys, has described here
If you use "Primary keys generated by the database" it doesn't give you freedom to create the key that you need for that table?

With best regards
Sergio Agostinho
5 years 3 weeks ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Primary Key forced to use or Compound Key? #4992
Hi Ingo,

Compound keys are not supported. What you can do is create a view in Oracle that combines the key fields into a single field. I can imagine that that is not very good for the performance, but probably that is not an issue in this case.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
5 years 3 weeks ago 5 years 3 weeks ago by Ingo Sterthaus. Reason: corrections made
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Topic Author
Primary Key forced to use or Compound Key? #4994

Sergio Agostinho wrote: Hi Ingo,

In step 4 of the database wizard you can change the way that CardExchange handles the table keys, has described here
If you use "Primary keys generated by the database" it doesn't give you freedom to create the key that you need for that table?


Thanks for the info guys. The problem is that the key is not unique as I am not able to set it as compound key. Without an unique key CE always throws an error message about duplicated entries. The only solution will be a new view to the table as Rutger said or the option to allow duplicate entries in CE. The error message is the cause why I asked for an option to disable the Primary Key.

Regards Ingo

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
5 years 3 weeks ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Primary Key forced to use or Compound Key? #4996
Hi Ingo,

If you intent to enter the compound primary keys manually, another option would be to use another field as primary key than the one set as such in the database, if there is any field that is unique for each record (or if you can add such a field).

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
×

Notice

The forum is in read only mode.