AnsweredAssumed Answered

Composite Keys in Azure Database

Question asked by TomDevonald1411 on Jul 14, 2016
Latest reply on Jul 14, 2016 by rohan_jain



I am building a few processes from SAP ByDesign to an Azure Database through the database connector. Whilst I can insert records in to the database with no problems, in the future a requirement will arise to update these records.


I have created an operation/profile to dynamically update the database. Do I now need to have two conditions, both 'equal to' in order for the data to find the record it needs to update? The fields that are the composite key in the DB are 'Invoice_ID' and 'Invoice_Date' so these would be the conditions? Hopefully this all makes sense but please say if not.


Thanks for your help in advance.