mardi 5 juillet 2016

Data too long for column 'descr' at row 2


When I try this sql statement to execute

update claim cl set search_field = (select  concat(cl.claim_description,' ', cl.legal_basis,' ',co.name) from contact co where cl.probable=1 and cl.search_field is null and co.id=cl.contact_id)

I get error above, and there is no column named descr. There is column named claim_description but it isn't descr

Does anyone have hint? Thank you


Aucun commentaire:

Enregistrer un commentaire