S
shilpi.agarwal3373
Guest
My ques is:- Is there any way to process the trigger which is defined in Sql server in rollbase application or I will have to create a new trigger in rollbase for the unique customer name? If latter one is chosen so again my issue is :- Cann't I access the sql trigeer in rollbase app? Because when i create a new customer or update or delete from rollbase app then the changes reflect in database also. So why Cant we use the sql trigger in rollbase? Trigger in sql server is USE [MyCustomer] GO /****** Object: Trigger [dbo].[tgr_Customer] Script Date: 18-12-2015 13:02:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[tgr_Customer] ON [dbo].[Customer] AFTER INSERT AS BEGIN DECLARE @cust_name varchar(50) SET @cust_name = (SELECT Custname FROM inserted) IF (SELECT COUNT(*) FROM Customer WHERE Custname = @cust_name) > 1 BEGIN ROLLBACK TRANSACTION RAISERROR('Customer %s alreay exists', 1,1,@cust_name) END END
Continue reading...
Continue reading...