Třídová akce

Kód:

6

Tělo:

UPDATE {TABLENAME} 
SET {TABLENAME}.{ExtraFieldName} = 
  (
    SELECT {CAST}
    FROM {DataTableName} B 
    WHERE {TABLENAME}.ID = B.ID and B.CLSID = :CLSID AND B.FieldCode = :FieldCode
  )
WHERE
  (SELECT COUNT(*) FROM {DataTableName} B WHERE {TABLENAME}.ID = B.ID AND B.CLSID = :CLSID AND B.FieldCode = :FieldCode) > 0
  {ANDWHERE}

Generated by ABRA Software a.s. 27.10.2021 16:34:12