Skip to Content
0
Former Member
Oct 26, 2022 at 02:21 PM

CAP Application Schema CDS Many-to-Many Column not found

51 Views Last edit Dec 22, 2022 at 06:09 AM 2 rev

Hi Everyone,

I'm having an issue with the establishment of a many-to-many relationship in my schema.cds. I'm getting the following error in the entity table called CCA_membership

[ERROR] in cds.deploy(): SQLITE_ERROR: table CCA_membership has no column named student in:
INSERT INTO CCA_membership ( student, cca, position , createdAt, createdBy, modifiedAt, modifiedBy ) VALUES ( ?, ?, ?, ?, ?, ? )
Query {
  INSERT: {
    into: 'CCA_membership',
    columns: [ 'student', 'cca', 'position' ],
    rows: [ [ '1', '1' ], [ '1', '2' ], [ '2', '1' ], [ '2', '2' ] ]
  }
}<br>