w testach automatycznych próbuję dodać pewien rekord z numerem.. wykorzystuje 2 tabele do uzupełnienia.
Dlaczego pojawia mi się błąd taki jak w temacie?
public void addRecord(String customersId, String campaignsId, String number){
String sd = "'{\"nowe pole 1\":\"}'";
String query = "INSERT INTO workforce.records("+"customers_id," +"campaigns_id," + "values)"
+ "VALUES (" + customersId +"," + campaignsId + "," + sd +");";
//dodajemy numer do rekordu
String query2 = "INSERT INTO workforce.record_numbers(records_id,number)"
+ "VALUES("
+ "(select id from workforce.records where customers_id ="+ customersId +" and values ="+ sd +"),"+ number+ ")";
connectDb.query(query);
connectDb.query(query2);
}