Does Datatable's Editor component support updating rows with composite primary keys?

Basementjack

I have an application that uses multiple fields for the primary key.
Is this supported by DataTables?

For example:

Customers 1/2/3 etc

But for invoices the data looks like this:
Cust:1, Inv;1
Cust:1, inv:2
Cust:2, inv:1
Cust:3, inv:1

note that there is no single field that uniquely defines the records, but the combination of Customer and Invoice is always unique.

So an update statement needs to set both fields
ie Update "invoices" set fieldx to 123 where Customer = 1 and Invoice = 1

allan

Is this supported by DataTables?

Yes by DataTables (since it doesn't really "care"), but no, not by Editor. Compound keys is something that I plan to add support for in a future version of Editor, but it is not yet supported.

Regards,
Allan