Multiple Primary Keys

Gayu123

Hi I would like to query two or more tables on a single page in different tabs.
Each table has a different Primary key.
How can this be added in the Editor?
Is this feature available?
I have done a lot of research but couldn't seem to find a solution.

allan

Hi,

Per the other discussion you posted in this is not a feature that Editor has yet. It will in future, also I can't say for certain when.

Allan

Gayu123

Thanks Allan for the quick reply.

I wasn't referring to composite key, That's why I opened a new Question.
I would like to have two different tables on the same page with a primary key for each table separately.
Is this possible?
Could you please guide me as to how this can be be done?

allan

Oops - sorry. Yes it is. Use the idPrefix method in the PHP libraries (IdPrefix in the .NET libraries) to set the prefix value - that will ensure that there is no conflict between rows that could otherwise potentially have the same id.

The third parameter of the PHP Editor() constructor can be used to change the primary key column name from the default of id if required.

Allan

Gayu123

Thanks. That works .:)