Třídová akce

Popis:

Vymaže hodnoty uživatelské položky podle předaných parametrů

Kód:

4

Tělo:

UPDATE {UserTableName} C
  SET C.StringFieldValue = '0'
WHERE
  (C.FieldCode = :FieldCode) AND (C.CLSID = :CLSID) AND
  C.ID in (
    SELECT  
      B.ID
    FROM
      MonthWRelationInformation A, {UserTableName} B
    WHERE
      (A.ID = B.ID) AND
      ((A.WorkingRelation_ID = :WrkRelationID) or (:WrkRelationID = '0000000000')) AND
      ((A.WagePeriod_ID = :WagePeriodID) or (:WagePeriodID = '0000000000')) AND  
      ((A.WagePeriodAuthor_ID = :WagePeriodAuthorID) or (:WagePeriodAuthorID = '0000000000')) AND
      (B.FieldCode = :FieldCode) AND (B.CLSID = :CLSID)
 )

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