Multiple key fields

Multiple key fields

Dennis ChanDennis Chan Posts: 18Questions: 8Answers: 0

Does the current version support only single primary key?
If there are more than one key, is there any way to handle this scenario?

This question has accepted answers - jump to:

Answers

  • allanallan Posts: 63,831Questions: 1Answers: 10,518 Site admin
    edited December 2016 Answer ✓

    Editor 1.6 will support compound keys, where the primary key is made up of multiple columns.

    As far as I am aware it isn't possible to have more than one primary key per table, although you can have multiple keys (that is largely irrelevent to Editor).

    The one important proviso is that the fields that make up the compound primary key data must be submitted by the client-side. They cannot be generated by the database.

    Allan

  • Dennis ChanDennis Chan Posts: 18Questions: 8Answers: 0

    Hi Allan,
    When will editor 1.6 be released?

  • allanallan Posts: 63,831Questions: 1Answers: 10,518 Site admin
    Answer ✓

    Tomorrow or Wednesday.

  • Dennis ChanDennis Chan Posts: 18Questions: 8Answers: 0

    Hi Allan,
    I downloaded release 1.6 but the DataTables.dll inside is still 1.5.6.
    Please check.

  • allanallan Posts: 63,831Questions: 1Answers: 10,518 Site admin
    Answer ✓

    Apologies - it is fixed now. A packaging error.

    Allan

This discussion has been closed.