Someone help me on converting the below query.
CREATE TRIGGER OALI_INSERT ON OALI
AFTER INSERT
AS DECLARE
@ItemCode nvarchar(50);
SELECT @ItemCode = ins.OrigItem FROM INSERTED ins
BEGIN
UPDATE POSOITM SET UpdatedDate = GETDATE() WHERE ItemCode =...
could someone explain me, what am i doing wrong in here.
if :object_type = '4' and (:transaction_type = 'A' or :transaction_type = 'U') then
begin
update OALI set "Remarks" = (select "U_ECH_PartNoStatus" from OITM where "DocEntry" = :li...
