Oracle APEX 4.2 primary Key?

Question

All,

Just a quick question. Is there still a restriction on APEX on the number of separate columns that a primary key can be built on?

In previous versions, APEX only supports upto 2 column primary key?

Any help will be greatly appreciated.

Thanks Prasad

Answer 1

Yes that restriction still exists. However, in the next release (Apex 4.1) I have heard that there will be the option to use ROWID instead of the primary key for forms, which will overcome this limitation.

See the Statement of Direction:

Use of ROWID – Allow usage of ROWID for Automatic DML processing (as an alternative to identifying the PK columns).