Aqua Data Studio 15.0.0-dev-258
Build #: 37602
Built on: 2014-Apr-29 03:48:52 PM
Operating Environment: Windows NT (unknown) (6.2, amd64) / Cp1252 / en / IN / Sun Microsystems Inc. 1.6.0_29-b11
Memory: Max=704,643,072; Total=340,066,304; Free=180,992,816; CPUs=8
Connect Sybase ASE 15.7
Create table:-
1.
CREATE TABLE "dbo"."EmployeeEast" (
"empid" int NOT NULL,
"empname" varchar(30) NOT NULL,
"empdob" datetime NOT NULL,
"region" char(5) NOT NULL,
PRIMARY KEY CLUSTERED("empid")
WITH max_rows_per_page = 0, reservepagegap = 0
)
LOCK ALLPAGES
GO
2.
CREATE TABLE "dbo"."EmployeeWest" (
"empid" int NOT NULL,
"empname" varchar(30) NOT NULL,
"empdob" datetime NOT NULL,
"region" char(5) NOT NULL,
PRIMARY KEY CLUSTERED("empid")
WITH max_rows_per_page = 0, reservepagegap = 0
)
LOCK ALLPAGES
GO
Create trigger:-
CREATE TRIGGER "dbo"."EmployeesInsertTrigg" on Employees
instead of insert as
begin
insert into EmployeeEast select inserted.empid, inserted.empname, inserted.empdob, inserted.region from inserted where region = 'East'
insert into EmployeeWest select inserted.empid, inserted.empname, inserted.empdob, inserted.region from inserted where region = 'West'
end
GO
Step to reproduced:-
1.Go to database tree node and expand it
2.Select trigger tree node and expand it
3.Select trigger "EmployeesInsertTrigg",and right click on it
4.Select Trigger properties option, display Trigger properties window
Now you will observe that, Missing schema name 'dbo' and double Quote for trigger name.
