In the sql statement attached, I would also like to update another field called "Part_of_no_of_Derived" in the point table in the same statement. I would actually like to increment this field by '1'. "Part_of_no_of_Derived" is an integer field in the point table.
I have tried different ways, one of the error I get during compile is "left side cannot be assigned to".
Would appreciate a quick solution. Thanks
function TAddDerivedPointsForm.ChangeAidRpt(aid: string): boolean;
with DMForm.Q_blank do
SQL.Add('UPDATE point set Report = 4 WHERE ( P$RTUID = :vRtu ) AND (AID = :vaid )');
ParamByName('vRtu').AsInteger := DMForm.T_RTURTUID.AsInteger;
ParamByName('vaid').AsString := aid;
result := TRUE;
result := FALSE;