I'm having an Access FE with SQL server 2014 BE. when adding a record via ADO and trying to Retrieve the Identity ID I'm getting An error "Record is deleted"
as per my research, it has to do with having a trigger "For Insert" but the trigger is only adding a record to an unrelated table, so I'm not sure what's going on over here.
as per my research, it has to do with having a trigger "For Insert" but the trigger is only adding a record to an unrelated table, so I'm not sure what's going on over here.
Code:
ALTER TRIGGER [dbo].[billingPay.Insert]
ON [dbo].[BillingPay]
FOR INSERT
AS
BEGIN
INSERT INTO [dbo].[Transactions]
([TransID]
,[Type]
,[Date]
,[Amount]
,[Balance]
,[Rep]
,[CustomerID]
--,[Project]
--,[ToPrint]
--,[ToEmail]
--,[Applied]
--,[ProjectID]
)
select BilingPayID,'Payment',getdate(),[Amount],[Amount],Rep,CustomerID from inserted
--end
--EXEC UpdateCustomerBalance @CustomerID
SET NOCOUNT ON
END